Subject Re: [IBO] Transaction with master-child relationship
Author Helen Borrie
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....

Helen