I have recently started working with FileMaker and do really enjoy it. I have started to work on this project but I need help with this small function.
Basically, I have number of clients and I would like to search client from drop-down menu. As you can see in picture, the dropdown box with red border has a name of client. I'm getting the clients name from field (client) from database table.
The first problem is that if i select a name of the client, which ever client record is currently open, the field will update the name to selected name.
Secondly, how i can have this dropdown, so when i select the name. the related records of that client show in portal below.
Thank you everyone in advance.
Feel free to contact me: Muhammad.email@example.com