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.