hi, this might be very simple, but I'm just learning (and I have been searching for an answer for a while!). How can I find based on whether two fields are identical or not? That is, I want to be able to 'find' all records wherein two particular fields are identical. Also, one of the fields is a portal. I've tried various things, but nothing seems to work, and it seems it should be really basic. Help?

-dez

You need to create a calculation, and use the Exact Function. This will give you a Boolean result, 1 if they are exactly the same and 0 if they are different. Then just do a find based on 1 in that field.

New Field

Thanks very much Lee, it worked.

I had tried this already and it didn't work, but your affirming that it should made me explore it a bit more, and I found the problem. I hadn't realised that, as one of the comparison fields is a portal, I have to reference it differently to referencing a non-portal field.

Thanks again!