Rocky Smolin
rockysmolin at bchacc.com
Mon Oct 3 11:25:59 CDT 2011
Dear List: I have a subform which has as its record source a query which joins an Account Receivable table to an account table: SELECT tblAccountsReceivable.fldARID, tblAccountsReceivable.fldAccountNumber, (*** bunch of other fields***) FROM tblAccountsReceivable LEFT JOIN tblAccounts ON tblAccountsReceivable.fldAccountNumber = tblAccounts.fldAccountNumber ORDER BY tblAccountsReceivable.fldARID; where Account Number is the PK of Accounts and the FK in AccountsReceivable. The subform is a continuous form showing the receivable records. When I select a record and hit the delete key the receivable record is deleted but also the Account from tblAccounts! I get the "You are about to delete..." warning message. No cascade delete. I can't understand why it would delete the account. The relationship in the query is one-to-many: one Account, many Accounts Receivable records. Any clues? I'm stumped. MTIA Rocky