AnsweredAssumed Answered

Relationships and Lookup fields?

Question asked by kilbot on Feb 16, 2010
Latest reply on Feb 16, 2010 by philmodjunk


Relationships and Lookup fields?


I have two tables that I have made a relationship with a field called FirmID. On layout when I place the firm ID# into the field it performs a lookup on the Business_Name. Both the FirmID and the Business_Name are repeating field with up to 20 repititions. When I place a firm ID into the 2nd repetition it shows nothing in the BusinessName field what am I doing wrong.


The Business_Name field is a lookup 

FirmID is not