Hi Tom and AS thanks for the assistance. I tried your rule Tom and I am still continuing to have errors. I will try creating a new BSV and try the rule again. It still gives me the same error. (
I tried a brand new bsv and encountered the same problem. It now allows me to add a single MAIN record to each Person but not multiple address records.
I'm 100% why the other rule does not work, but try this:
If Address IS NEW AND EXISTS Address WHERE (Address.Main='Yes' AND Address.Person=ThisAddress.Person AND Address.ID<>ThisAddress.ID) AND Address.Main='Yes' Then
REPORT ERROR 'Only one main Address can exist'