Compare fields between layouts
I am trying to perform data validation using File Maker Pro. I have two matching layouts, Table1 and Table 2. When someone enters data into Table1, there is no validation involved. I will have a different user entering data into Table 2. At that point, I want it to validate the data against table 1.
So , in table 1, if i have the fields
Field A - primary Key
and in Table2, i have the fields
Field A - primary key
When they enter data into Table2 for Field B, it should check
Table2.FieldB = Table1.FieldB AND Table2.FieldA = Table1.FieldA
If this does not pass validation, I don't want to save the data.
I dont know if there is another way for data validation...
If there is, please let me know.
I have never used Filemaker Pro and this is my second day ....
Thank you in advance for your time & suggestion. Your help is greatly appreciated!!!
FMP NewBie :)