Access data entry and varying datasets
Posted on 2012-09-07
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
Now, there will be a
1st Proposal - normally followed by a
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.