Search results

right I understand but when I click one work item and one sub i still get more records than requested.....

I tried and it is either duplicating the work items or not showing all of the work items when I select a work item and then select a subcontractor. I have attached the db. for the changes because i have made a few cosmetic changes that I would like to keep. I love where this is headed. You are...

Thanks again! I am still having trouble with the form that opens when the db does. This is what is happening. I select a dicipline and then if I try to select mulitple work required items and then select a sub when I go to the next page it is blank. Also if I select a discipline, then only...

Wow that is exactly what I needed! thank you so much for your help!! I am however having a problem opening the form that opens when the db opens. I am unable to select a subcontractor in order to move to the next screen. Please advise. Thanks so much

password: LOCK (all caps)

The fields needed in the quote form are work item, title, work required, sub discipline, Sub Quotes 1-8

Ok i came up with an idea to upload my sample db to the internet because I have no idea what you are talking about lol :banghead: Here is the site: www.drivehq.com my login is: lowanam1 password : shiprepair2009

I tried that doesn't work either....so I can give you the naming conventions...and you can walk me through how to put the code? Will that work ? Thanks This is exactly how I have the tables named: tbl_Disciplines tbl_RateTypes tbl_SubcontractorQuotes tbl_SubcontractorRates tbl_Subcontractors...

Your submission could not be processed because a security token was missing. If this occurred unexpectedly, please inform the administrator and describe the action you performed before you received this error. This is the error that I get when I try to upload. I could email it to you?

ok that works for me

The form should be in datasheet view...other than that I don't have a vision just whatever works best. Let me know your thoughts. Thanks for your help

ok got it. I added a discipline column to the tbl_subcontractors. I cannot upload word documents that is why I am taking pictures....might be a work restriction or something

attached is what I have changed....

I have attached a photo of the relationships that I have. Thanks

Each subcontractor is broken down by discipline. There are tank subs, stage subs, paint subs, sandblast subs, etc. So when subs turn in their quotes it is for a particular discipline broken down per work item. for example: a stage sub will send one quote that has all the stage work items and the...

tblSubcontractorQuotes -pk=SubcontractorQuoteID primary key, autonumber -fk=Reference Number foreign key to tblWorkRequired -fk=Company Name foreign key to tblSubcontractors -txt=Quote Status -nmb=Man Hours -cur=Material -cur=Total -txt=Sub Exceptions -txt=Award Justification -txt=Award Percent...

Ok I rearranged my tables to reflect all of your advice. The way that I related the work items and disciplines were by the reference number in the subcontractor quote table and the work required table. i.e. stage63111001, tank64180001....is that a good way? Please advise. Thanks again

tblWorkItems -pk=Work Item Number -txt=Estimator -txt=Work Item Status -txt=Specification Status -txt=Package Type -dte=Rec'd Date -txt=Smart Start -txt=Critical Path -txt=Work Item Title -txt=Specification -txt=Amendment -txt=Allocation after PMO tblWorkRequired -pk=Reference Number -txt=Work...

When each quote is created is ideal. I am unable to upload a sample at this time. :(

i have a select query set up and broken down by discipline "qry_Stage Quotes" however i can not get the append function to work without freezing the query so that new information can be entered..also how do i get the work item to associate with the other quotes? Am i doing something wrong...