Populate text boxes based on 2 combo boxes?

[jzwp22]

I only have Access 2003 here at work, so I will take a look at the DB from home tonight.

 

[jzwp22]

The overall structure of your database is correct, but the foreign key fields have to be long number fields in order to join properly to their respective primary key fields. I have made the changes in the attached DB.

 

[mwisejay]

Thank you so much for all you're help. I have lots of data to move out of those tables now! But at least I'm in the right direction now.

 

[jzwp22]

You're welcome; good luck with the project.

 

[SmallTime]

Fantastic job jzwp22. I tip my hat to you.

Smalltime

 

[jzwp22]

I'm glad you were able to find the thread useful.

 

[mwisejay]

jzwp22,

Could I just do away with the tblActualVsProposed table and under ChargeType in tblChargeType add 3 more records for ProposedLabor, ProposedODC and ProposedTravel to the current records in that table (ActualLabor, Actual ODC and ActualTravel)?

 

[jzwp22]

Since a charge such as labor can be of either two types (proposed or actual) that is a one-to-many relationship. Thinking about it further, it might be better to associate the charge type (labor, ODC, other) to whether it is proposed or actual in a table and then reference that in the contract charges table. This will replace the 2 fields in tblContractCharges with 1 field as shown below

tblChargeType (records for each: labor, ODC, other)
-pkChargeTypeID primary key autonumber
-txtChargeType

tblProposedorActual (you might have a better name, but this table would hold the two names: proposed and actual each as a record)
-pkProposedActualID primary key, autonumber
-txtProposedorActual

tblChargeTypeProposedorActual
-pkCTPAID primary key, autonumber
-fkChargeTypeID foreign key to tblChargeType
-fkProposedActualID foreign key to tblProposedorActual

tblContractCharges
-pkContractChargeID primary key, autonumber
-fkContractID foreign key to contract table
-fkCTPAID foreign key to tblChargeTypeProposalorActual
-ChargeAmt

Having records such as this: ProposedLabor, ProposedODC, ProposedTravel ActualLabor, Actual ODC and ActualTravel will make it harder to filter the data if you want to work with the charges from the groups separately.