Combo Box Help - need value from 3rd Table.

S

Steve Lowe

Hi,

My Access 2000 application has 3 tables in it

TblAccounts, TblTransactions, TblTaxRates

I hold the details for subcontractors in TblAccounts, eg names,
addresses etc. Each record has a unique autonumber field called
TblAccounts.AccountID

Depending on their status when a subcontractor is paid tax has to be
deducted from their payment at 1 of 3 rates.
The tax rates are held in the TblTaxRates
A field in the TblAccounts called TblAccounts.Taxrate is related to
TblTaxRates.TaxID

I have a form called frmPayments based on tblTransactions. On this
form I have a combo box for the TblTransactions.AccountID field which
is related to the TblAccounts.AccountID field so the user can select
which subcontractor is being paid.

I'm having a problem with setting up a combo box on the frmPayments
form for a field called TblTRansactions.Taxrate - this needs to be
populated with the taxrate held in the TblTaxrates indicated by
TblAccounts.TaxRate

Since the tax rate could change in the future the value held in
TblTransactions.Taxrate needs to hold the tax rate applicable at the
time the payment was entered.

Any pointers would be appreciated.


Regards

Steve.






- Steve Lowe
- E-Mail : (e-mail address removed)
- Before Replying Remove .NO.SPAM
- UK Resident although my e-mail address is usa.net
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Box Selection is Blank 1
Automatically generating text entries from combo box 4
Can you send values from 2 columns in a Combo Box to 2 text boxes? 2
Referencing from a combo box 4
Populate a text box from a combo box selection 0
Table as source for combo box 1
Linking Combo Box Values to Access Table 2
Problems with update table with combo box 2

Top