AnsweredAssumed Answered

Related file lookup

Question asked by cowtrax on Jan 20, 2012
Latest reply on Jan 20, 2012 by philmodjunk

Title

Related file lookup

Post

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.

Thanks.

Outcomes