Method Community

When using the Grid Wizard, what determines the list of tables you can choose from for the "Attached" option?  How do you get a table to appear in that list?

Hi,

The tables listed under the attached option are tables that reference the table that the screen is created off of. As an example if I selected the Activity table as the main table for the screen the attached tables that i would be able to select are any tables that have a drop down that reference the Activity table (ActivityJobItems is one example).

-Michael 

How do you create a drop down in one table that references another table?

Hi JKM@SA,

To do this you will need to add a drop down field to your table by going Customize > Tables / Fields and clicking Edit Fields... on the table you want to add a drop down field to . Drop downs can be created based on unique field in other tables.

-Michael