AnsweredAssumed Answered

What is the reason(s) to have multiple key fields in a table?

Question asked by user2147901 on Dec 13, 2018
Latest reply on Dec 17, 2018 by BruceHerbach

Hi, I am new to filemaker. I have seen several solutions using multiple key fields in a table. For example, id_text, id_number, uuid, no.(as numbers I think). Each key field is used in different relationships with different tables.

 

I don't understand why the design is like this. To my knowledge, one key field is used as primary key, if I need a relationship, I should create a foreign key to relate to other tables. As a result, I don't know which one is the primary key of that table.

 

Each table in the file is created like this. If it is created when needed, I think it is ok, but all the tables structure like this. Is there any reason about this approach? Is there any advantages to create a table like this?

 

My description may not be clear. Please let me know.

Outcomes