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



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.