Search results

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)?

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.

Sorry, I didn't see the error message that the PDF had to be under 100 KB before I hit sent. I've attached as an accdb file.

So if I add a fkActualVSProposed field to the tblContractCharges (reverting away from the duplicate tables of proposed and actual), would this attachemnt reflect how this would then appear?

Not truely clear on where to go from that. If it makes any difference, I should be the only user of this database and will use it to produce reports at the request of leadership.

I'm starting fresh here so I don't think it was letting me select that option yet because there is no data in the tables yet. I think you've really helped my understanding of how the tables should be constructed and how to relate them to each other. Reading a book can only help until you have...

Ok I think I got it.

So I should add an fkContractNumber field in tblChargeType to relate to the fkContractNumber in tblContractCharges?

I've attached a PDF of the relationships. Does this look right?

jzwp22, Ok, I think I get what you're saying and now I'll have plenty to do the rest of the week to rework my tables into a single table :) So I should have: tblContracts: (basically information about the contract. will be used as header information on reports reporting the finances.)...

jzwp22, I plan to use the database to record the monthly charges for each contract. That's why I made each contract its own table as each record is a month charged. Since each contract is for a set period of time I already have the months recorded in each record. Wanted to use the Form and...

Using ACCESS 2007, I have two combo boxes. The first lists all the Tables in the data base. Each table is a contract where I record monthly costs. Based on the table selected from the first combo box the second combo box lists the ReportingPeriod field from the contract table selected in the...