--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:

> At 07:03 AM 8/12/2003 +0000, you wrote:
> >Hi,
> > I encounter a *scratch-head* reaction with my master-child
> >relationship transaction. My master and child tables are CUSTOMER

and

> >ADDRESS respectively. I've set their relationship according to the
> >TransactionsHandling tutorial lesson 2.
> >
> >Info on child IB_Query:
> > MasterLinks: ADDRESS.ID=CUSTOMER.CUST_ID
> > MasterSource: DSCustomer
>
> Are you sure this relationship is correct? Surely, your detail-to-

master

> link should be through a foreign key in the ADDRESS table -

ADDRESS.CUST_ID

> or something similar. ADDRESS.ID seems like it would be the
> **primary key** of the address table....

The primary key of ADDRESS table is (ID, ENTITY, ADDRESS_TYPE). I
intend to use this table to store addresses of customers, vendors and
etc. Therefore I have the ENTITY field to identify the address is for
what kind of entity. ID will be the ID of that entity. ADDRESS_TYPE
will be either 'Billing', 'Delivery' and etc.

I did not create a foreign key in my ADDRESS table because I can't.
This table *references* different tables based on the ENTITY field.

Do you mean the absence of a foreign key is the reason why it won't
work?

> Helen