AnsweredAssumed Answered

Search Record From Another Table By Name And Import That Data

Question asked by clagrange on Jul 23, 2018
Latest reply on Jul 29, 2018 by tomr303


Hello,

 

I am extremely new to FileMaker and I might be having trouble understanding a simple problem.

 

I have two tables in my database.  Account Managers and Accounts.

 

In my Accounts layout, I would like to have a field where I can search for Account Managers by Name and import more data from that specific Account Manager into my Accounts layout.  I have found a way to perform a look-up with the Account Manager ID, but I have to enter the ID manually.  If possible I would prefer to search by name. 

 

Can this be done?

 

Let me know if you need more information.

 

Thanks,

 

Chris

Outcomes