AnsweredAssumed Answered

Excel data without primary key

Question asked by user2147901 on Aug 2, 2018
Latest reply on Aug 3, 2018 by onefish

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.

Outcomes