Allowing creation of records whilst stopping duplication with linked tables
Any help appreciated. New to File Maker pro so bare with me.
Managed to make myself a client database.
Have a table with client info then about 7 other tables for the other people who interact with the client, for example GP's or Physio's.
On the client page I have all the client details and then the names of all the other professionals involved with them. I have it set up so that I can type, for example, the Physio's name in and it will automatically generate their record on the corresponding Physio page/table. Also I have added a button which will send you to the record.
The issue. When one Physio see's multiple clients. I.E. If I create a record for a new client and they have the same Physio as another client when I type in the Physio's name in on the client page it will create a new record on the Physio table, resulting in a duplication. What I need it to do is link to the existing record.
How do I do that?