N
Nitram Naed
I have a number of tables:- tblCustomer, tblPrduct, tblAddress, tblExtras and
tblPayment.
They are all linked by the CustID number.
I am using enforced referential integrity to cascade up and down with all of
these tables to allow me to delete linked records.
To complete a sale, I need to update just a few fields in each table -
delivery date, payment date etc.
I have a separate "Delivery" form with the appropriate fields on it, that
would update the relevant tables automatically. This for opens via a button
on the main Order form, and copies the Customer ID number onto the "Delivery"
form.
The problem seems that if a table does not have a record of an individual
sale, for example, if a customer did not by any extras, the Customer ID
number won't carry over, and an update of the other tables won't happen.
I suspect this is because of the Referential Integrity.
Can anyone help with this?
Thanks for your help in advance.
tblPayment.
They are all linked by the CustID number.
I am using enforced referential integrity to cascade up and down with all of
these tables to allow me to delete linked records.
To complete a sale, I need to update just a few fields in each table -
delivery date, payment date etc.
I have a separate "Delivery" form with the appropriate fields on it, that
would update the relevant tables automatically. This for opens via a button
on the main Order form, and copies the Customer ID number onto the "Delivery"
form.
The problem seems that if a table does not have a record of an individual
sale, for example, if a customer did not by any extras, the Customer ID
number won't carry over, and an update of the other tables won't happen.
I suspect this is because of the Referential Integrity.
Can anyone help with this?
Thanks for your help in advance.