At 05:32 PM 8/12/2003 +0800, James Chua wrote:

> > 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 is right. Your master child relationship ins't setup right.

The child-master relationship seems OK. If you re-read Alfred's
description, you will see that the Address.ID field is the
Customer.Cust_id. The problem lies somewhere else, possibly in the KeyLinks.

Helen