function question

[cfalab]

Hey Guys -

I have a database that serves as a rental system, and there's a field that counts the number of time conflicts with each new reservation. I want to create a new field that will check the conflict field for all existing records and enter "Yes" if there is a record with a conflict number higher than 5, and "No" if there is no number higher than 5.

Any tips on what function/calculation to use?

Thanks a lot.

[Fitch]

To work with all records you'd need a Cartesion relationship (i.e. the "x" option in the relationship dialog). Then I suppose:

Case( Max(related::conflict) > 5; "Yes"; "No" )