AnsweredAssumed Answered

Table / Field Comparison

Question asked by ChrisSmythe on Oct 27, 2012
Latest reply on Oct 27, 2012 by ChrisSmythe

Title

Table / Field Comparison

Post

     Hello, I am using FileMaker Pro 12 on Windows XP.

     I am hoping someone would please be kind enough to help me with the following FileMaker Table/field comparison:

     I have a link to my Test 11.fmp12 database (Account Name: Admin & Password: "there is no password" just click OK.

     https://www.sugarsync.com/pf/D0681807_60165357_21551

     I need a script to compare the following fields within the following two tables:

     DbUserEdits table --- LinkToEmployeeID field; and
     Personnel table --- EmployeeID field.

     If there is no matching record with a LinkToEmployeeID field in the DbUserEdits table with a corresponding EmployeeID field in the Personnel table, then
     the record associated with the LinkToEmployeeID field needs to be deleted from the DbUserEdits table.

     I hope this makes some sort of sense - I am a newbie.

     Any help would be greatly appreciated.

     Kind regards,

     Chris :)
      

Outcomes