A
Ann Shaw
Hi whoever can help!
I have a table with the following:
Prod ID - Primary Key
Prod Name
Desc
Also
Order ID - Primary Key
Qty
Date
Lookup to Prod Name
I have found that if there are no orders in for a certain
product, then I can delete the product from the table even
with the relationship (one to many) If there is an order
in I cannot. How can I get it to stop the deletion if
there is no order in place.
Thank you in advance
Ann (Ireland)
I have a table with the following:
Prod ID - Primary Key
Prod Name
Desc
Also
Order ID - Primary Key
Qty
Date
Lookup to Prod Name
I have found that if there are no orders in for a certain
product, then I can delete the product from the table even
with the relationship (one to many) If there is an order
in I cannot. How can I get it to stop the deletion if
there is no order in place.
Thank you in advance
Ann (Ireland)