[AccessD] Delete Problem

I think you may have answered your own question there. Your query is essentially a table of accounts, with the receivables pulled in. When you select a record to delete, you are selecting the account. I would rework that query, use the FK to to pull the account in as a lookup instead.

Regards, Dean


On Oct 3, 2011, at 12:25 PM, Rocky Smolin wrote:

> 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
> 
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com