Hi John

Does it give you the linenumber ?

Walter,


>Hi,
>I have the following relationship between table
>
>Consultancy
>PK: iID
>
>Payment
>PK: iID
>FK : iConsultID
>
>PaymentDetails
>PK: iID
>FK: iPayID
>FK: iPayTypeID
>
>PaymentType
>PK: iID
>
>Consultancy.iID -> Payment.iConsultID 1:n
>Payment.iID -> PaymentDetails.iPayID 1:n
>PaymentType.iID -> PaymentDetails.iPayTypeID 1:n
>
>I get error "missing operand" at CREATE TRIGGER ... line while generating RI code. The error only happened if I have links involve payment, paymentdetails
>
>Any ideas?
>
>Thank you