This problem is solved with help from a previous answer from Duane. Thanks! Connie
--- In MS_Access_Professionals@yahoogroups.com, mrsgoudge <no_reply@...> wrote:
>
> 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
>
Tidak ada komentar:
Posting Komentar