Bewildering relationships
Posted: Wed Apr 30, 2008 8:05 amHi 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).
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).