And what is the relationship like between the two tables? One to one, one to many?
It sounds like you can do something like this:
Define a calculation field in the layout's table with this expression:
CostField = RelatedTable::CostField
select Number as the result type for this calculation
Then perform a find for the value 1 in this calculation field.
But the nature of the relationship between these two tables could keep this from working unless this is a one to one relationship or the Cost from the related field is a total of costs from the related records.
Won't I just replace the in the new field?
The relationship is 1 to 1.
Sku; xyz (linked data)
I want to know if the value in table 1 is different then in table 2. Does that make it clearer? Thanks for your help.
I missed the word "doesn't" in your original post.
Define cCostCompare as a calculation field with this expression:
Cost ≠ Table 2::Cost
This will not modify any data in any of your other fields in either table. It's a Boolean expression that will return the number 1 (True) if the values are not equal. So finding all records in Table 1 where cCostCompare is 1 will find all records where the values are not equal.