2 part question about logging in and out of filemaker and show names only linked to certain user
I have a table, Clients, and table, Trainers. Each client is linked to a trainer. Is there a way that when a trainer logs into filemaker with their username and password that it only shows their clients? Right now I have 40 trainers in the database and 1000 clients. This would make it a little easier to handle the information in the database.
Also when accessing the database it does not prompt me to enter username and password. What option am I missing in order for this to present itself each time I open the database?