Bewildering relationships

General support questions.
Posts: 34
Joined: Wed Aug 15, 2007 3:17 am
Location: Mediterranean
PostPosted: Wed Apr 30, 2008 8:05 am
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
and (e.g.)
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).
SeedCode Staff
SeedCode Staff
Posts: 2760
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Wed Apr 30, 2008 9:21 am
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 we can figure something out.
John Sindelar

Return to General Support

Who is online

Users browsing this forum: No registered users and 1 guest

Follow us: