By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,700 Members | 1,458 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,700 IT Pros & Developers. It's quick & easy.

Auto Data Entry

P: n/a
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
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.