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.