Hi, I am new to filemaker. I am wondering if we receive excel sheet data(more than 200 files, containing over 50000 data) without a primary key, but somehow the clients refuse to modify their data first, but agree to use primary key for new data. In this situation, if we are going to create a new file, new relationship, should we use other field data, like their employee name or their telephone to create relationship. is that any good approach to solve this issue?
I am using filemaker 17.