I have a table and related form "Listings". Also a table and related form "Sales". Listings and Sales have a one to one relationship and Enforce referential integrity is checked. Update and Delete are not checked. Sales has a foreign key "ListID" referring to a record in listings. When I delete a record from Sales form using code the related record in Listings is also deleted.
This used to work (only Sales record would be deleted) and no longer does. I have made quite a few changes and can not go backwards.
Because I want only records that have sold to show in the Sales form, its record source is Sales inner joined with
Listings with no fields from Listings included on the form. I have several combo boxes on the Sales form which have the Listings table as their row source.
Thanks!
Connie
Senin, 19 September 2011
[MS_AccessPros] Deleting a record also deletes the record from related table
__._,_.___
MARKETPLACE
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar