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