AnsweredAssumed Answered

Allowing creation of records whilst stopping duplication with linked tables

Question asked by TMoose on Feb 12, 2015
Latest reply on Feb 12, 2015 by philmodjunk

Title

Allowing creation of records whilst stopping duplication with linked tables

Post

Hi,

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?

Thanks

TM

Outcomes