delete multiple records from multiple tables
i have delete page set up where a 'store owner' can select multiple customers(with checkboxes) to be deleted from a 'shoppers' table. works great. what i'm wondering is if i can add the 'product' table to the delete command so that when it fires it will delete the selected customerS in the 'shoppers' table and their products associated with them in the 'cart' table. both the shopper and their products share a common identifier.
i'm using MS ACCESS...
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)