• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 737
  • Last Modified:

Access data entry and varying datasets

OK, now I've gotten myself into something that has be completely baffled.  

I Have a "Job" that needs to have a "Quote" there are specific field requirements like:
Date of Proposal
Total Square Feet
Total Cost
etc, etc

Now, there will be a
1st Proposal - normally followed by a
1st Response
then maybe a
2nd Proposal - followed by an agreement between parties (equaling a Final column) or
2nd Response - sometimes this could go back/forth several times

So my question is....How should this be set up?  Right now it's done using Excel (as a container not really as a spreadsheet) with several columns.  Any ideas would be greatly appreciated 'cause I'm stuck.
2 Solutions
It is normal data structure for Access DB. I see at least 3 tables:
1. Jobs with JobID and other fields
2. Proposals with JobID as foreign key, ProposalID and other related fields.
3. Responses with ProposalID as foreign key.
MAy be you will need separate table for Agreements and something else. Will be better if you show some sample in Excel.
You need to have a look at database normalization.
Try this link:

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now