Hello All,
New to access so sorry in advance hopefully i explained my thoughts adequately.
ID | JOB_NAME | JOB_DATE | TYPE | SIZE | etc...
1
2
Currently, each job has the information entered here, with just basic information about the job entered.
Then there is another form which has the various bids of us, and other companies, entered for each of these jobs in question..
ID | JOB_NAME | OUR_BID | COMPANY_1 | BID_1 | COMPANY_2 | BID_2 | etc..
1
2
Obviously this database doesn't work, as its just static, therefore I'm trying to link the companies to their bids so that I can create an additional sheet breaking out the companies with their individual bids, average bid price etc. Unfortunately, there is too many other companies on each job, and they change frequently, therefore having a field for each company wouldn't be feasible.
COMPANY | JOB TYPE | BID | AVERAGE_BID etc..
I can't exactly figure out a way in which I could do this, but I'm sure its a lot simpler then I'm making it. Any hints or tips would be greatly appreciated.
New to access so sorry in advance hopefully i explained my thoughts adequately.
ID | JOB_NAME | JOB_DATE | TYPE | SIZE | etc...
1
2
Currently, each job has the information entered here, with just basic information about the job entered.
Then there is another form which has the various bids of us, and other companies, entered for each of these jobs in question..
ID | JOB_NAME | OUR_BID | COMPANY_1 | BID_1 | COMPANY_2 | BID_2 | etc..
1
2
Obviously this database doesn't work, as its just static, therefore I'm trying to link the companies to their bids so that I can create an additional sheet breaking out the companies with their individual bids, average bid price etc. Unfortunately, there is too many other companies on each job, and they change frequently, therefore having a field for each company wouldn't be feasible.
COMPANY | JOB TYPE | BID | AVERAGE_BID etc..
I can't exactly figure out a way in which I could do this, but I'm sure its a lot simpler then I'm making it. Any hints or tips would be greatly appreciated.