### Title

Finding Data in Related Fields

### Post

Help!

I would like to perform a find within a layout where one field doesn't equal another.

(ex. I have a cost field and would like to find each record where the cost field does not equal another cost field from a linked table)

Is that possible?

Thanks,

John

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.