Auto Data Entry

S

Sue Ann

I have the following tables:

TblSaleDetail
SaleDetailID
SaleID
AccountCategoryID
AddendumDate
SellingPricePlusTax

TblAccountCategory
AccountCategoryID
AccountActivity
AccountNumber

TblAddendumDate
AccountCategoryID
AddendumDate

There are 7 records in TblAccountCategory that wll never change. The
AddendumDate in TblAddendumDate changes every 6 months and may be different for
some of the 7 Accounts. That's why I need to record it for each sale detail in
TblSaleDetail.

I have a query that includes TblSaleDetail and TblAccountCategory with a Type 2
join on AccountCategoryID. The query is updateable. I have a data entry form
based on this query and the form displays all 7 accounts with the AccountNumber.
SellingPricePlusTax will be entered in the form programatically for the
accounts. Some sales no not include all 7 accounts so SellingPricePlusTax will
not be entered for all 7 accounts each time.

I need the query to do more. I need the query to:
1. AccountCategoryID from TblSalesDetail is hidden on the form. I need it to be
set equal to AccountCategoryID in TblAccountCategory for each account
SellingPricePlusTax is entered on the form.
2. I need to include TblAddendumDate in the query and display the AddendumDate
for all 7 accounts.
3. I need AddendumDate in TblSalesDetail to be set equal to AddendumDate in
TblAddendumDate for each account SellingPricePlusTax is entered on the form.

All help is very much appreciated!!

Sue Ann
 
Top