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!