L
Lisa
I have a simple database for a home inspection business with three tables:
Clients, Jobs (one to many relationship of Clients to Jobs), and Real Estate
Agents.
I'm setting up the input form. All I now want to do is allow the user to
use a dropdown list to look up two separate Real Estate agents (one for the
Buyer and one for the Seller) and have their info populate the fields on the
form.
I have spent a lot of time on this, with different joins, different
autolookup queries, and separate tables for both Buyer and Seller agents.
Clearly I'm floundering and am at my wit's end. Please ... any help would be
greatly appreciated.
Clients, Jobs (one to many relationship of Clients to Jobs), and Real Estate
Agents.
I'm setting up the input form. All I now want to do is allow the user to
use a dropdown list to look up two separate Real Estate agents (one for the
Buyer and one for the Seller) and have their info populate the fields on the
form.
I have spent a lot of time on this, with different joins, different
autolookup queries, and separate tables for both Buyer and Seller agents.
Clearly I'm floundering and am at my wit's end. Please ... any help would be
greatly appreciated.