Table / Field Comparison
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.
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.