AnsweredAssumed Answered

Need Help for Find record script

Question asked by PeterChen on Jun 3, 2017
Latest reply on Jun 7, 2017 by PeterChen

I have 2 tables 'Employer' and 'Worker' and a field named "NationalityPref" in Employer table.

 

'Employer' and 'Worker' tables are related with a field named "EmpCode"

 

How should I write and structure the Find Script to do the following?

 

I want that:

if "NationalityPref" field in Employer table= Indian, find records in Worker table where "Nationality" field=Indian;

if "NationalityPref" field in Employer table= Filipino, find records in Worker table where "Nationality" field=Filipino and so on...

 

I'm quite lost with my FMPro 14 as I've been using version 5 for far too long:(

 

Thank you very much!

Outcomes