Help with auto fill
Hi - I'm sure this has been answered before but I'm having trouble joining two databases.
I have a Rolodex database that contains vendor information; company name, contact person, phone, etc. and a Purchase Order database.
From the Purchase Order database when I type in a company name that exists in the Rolodex database I'd like Filemaker to recognize this relationship and autofill the rest of the data [contact person, phone, etc.].
Please advise on the best way to do this.
Thank you. -S