[AccessD] Delete Problem

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
 
 
 




More information about the AccessD mailing list