AnsweredAssumed Answered

Related file lookup

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


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.