Access data entry and varying datasets

Posted on 2012-09-07
Last Modified: 2012-09-11
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.
Question by:napsternova
    LVL 39

    Accepted Solution

    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.
    LVL 30

    Assisted Solution

    You need to have a look at database normalization.
    Try this link:

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
    Read about how to approach blogging and about ways to do it right. Stand out from the crowd and let your knowledge be consumed by a large audience. This article aims to explain how your blog should look like,  the most important things to do while b…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now