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
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...