Hi John,

I have a few one-to-one self-joins defined for different types of contacts (clients, suppliers, interpreters, etc.).

I have them defined as multikeys, with
ContactID=ContactID
and (e.g.)
FlagIsClient=FlagIsClient
for the Client table occurrence

(the Flag fields are obviously Boolean, and either 1 or empty).

Some of these relationships are working fine, others appear to make no sense at all.

On top of that, I have a record-counting global calcs in Filters, e.g.
Count ( Contact::ContactFlagIsClient ) (calculated from ContactFilters). While there are 5 records flagged as clients in the Contacts view, this field is only giving me a result of 1. I don't understand what's wrong, since the relationship is universal.

Any suggestions? I'm getting panicky here (fearing for database integrity).

Hi there. Don't think I can really help without seeing the files. If you'd like to send the to me at john at seedcode.com we can figure something out.