Related file lookup
Is it possible to "call" a Table View of a file (table 2) from one layout (table 1), then select a record from that view and return it to the calling layout and place one of the fields (from table 2) into a field in table 1? I am trying to have a more flexible lookup of data from one file and placing the key from the lookup file (table 2) into the foreign key of the calling layout. Hope that makes sense. I am just trying to get around the limitations of the standard file lookup via value lists.