Forum Discussion

AswinBabu's avatar
AswinBabu
Qrew Member
5 years ago

Creating Dynamic fields in the child table

I have 2 tables. Table A is the parent and Table B is the child table, Table A have fields Name(txt), Dimensions(num), Description(txt). Table B should  have field Name but other fields like Length, Width1 and WIdth2 should appear based on the entry in the Dimensions field of parent table. 

i.e, if Dimension =1 then fields of child table B must be Name and Length only. 

If Dimensions= 2 then fields of child table B must be  Name, Length, width1 only

if Dimensions= 3 then fields of child table B must be Name, Length, width1 and width2.

Is this possible?



------------------------------
Aswin Babu
------------------------------
Relationships
Tables and fields
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago

    No Problem.

    Of course, those look up fields will exist on every child record so your real question is how can you control the display of the form to only give meaningful fields for the Dimensions.

     The name and length field will appear on all forms so there is nothing special required there. 

    To control when the field for width 1 shows set up a Dynamic Form Rule to show Width 1 when 

    any of the following

    dimensions is equal 1

    dimensions is equal 2 

     Then set up an additional dynamic form rule to control when Width 2 should show. 



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------