1 to 1 relationships

rbuser

I read a message that said that people were calling in for help on
this for no reason, but the message didn't really answer the question
that I have. I still don't understand how to force a 1 to 1
relationship.

I have 3 tables that all have 1 to 1 relationships, they look like
this:

TABLE1-----------TABLE2------------TABLE3
m 1 1 m

I have all of the links set to only include IDs from the linked table
that match the IDs in this table, this would force a 1 to 1
relationship right?

TABLE1 and TABLE2 are linked by the field cID and TABLE2 and TABLE3
are linked by the field oID

I have the report grouped on the oID in TABLE3 and I have 2 subreports
in the detail band. Now here is my problem. The action or adding a
field from TABEL1 acts like it terminates the 1 to 1 relationship and
gives me all the records in TABEL1 regardless of what is in TABLE2.
The only way I could get this to work, without anything from TABLE1 in
it, was to make TABLE2 the master table (it has the 1 side when it
shows the 1 to many relationship). It runs fine and gives me the 10
records I want, but everytime I add something from TABLE1 it gives me
everything from TABLE1, 45 records in all. I was wondering how to
force a 1 to 1 relationship. Would the new release fix this?

Thanks Jason

digitalmetaphors

I assume you are using DADE linking? Try 6.02, as we have put in fixes to
DADE for the latest release.


Cheers,

Jim Bennett
Digital Metaphors