AnsweredAssumed Answered

Help with relationship lookup

Question asked by greenhornet on Aug 13, 2018
Latest reply on Aug 13, 2018 by philmodjunk

I'm sure this is a relatively simple task, but for some reason, I can't get my brain around it today.  I have Table A in one database that contains customer info.  There is a "referred by" field.  I have Table B in another database that contains a "full_name" field.  As I enter customer details in Table A, I would like to begin typing the name of the salesperson in the "referred by" field and have it auto populate, pulling data from Table B, full_name.  I can't get the relationship to work.  What's a good way to accomplish this one?  I should add that I DO NOT want the ability to add records to Table B from Table A.  If the salesperson in the "referred by" field doesn't exist as a record in Table B, they should not be able to create a record from the related table A.

 

Thanks in advance!

Outcomes