Good morning - I have been tasked to add an estimate system to our current Access database using autonumbering for each new estimate.
I have very limited knowledge of Access and have basically taught myself (not that well!) to set up various forms/reports etc and this is my latest task.
I have managed to set up tables, a form and reports and it works quite well for what we need. However, the estimator has come to me with a problem which is above my remit i think...
My form only allows 1 cost per estimate, however, there are instances when multiple items need to be entered. We have got round this so far by exporting to a rich text Word file and amending manually, however, this isn't really ideal as if you search for the estimate on the DB it only brings up the original.
Is there anyway I could adapt what I already have to enter multiple lines on one estimate number? Not sure if it's something I should be using a sub form for but I've never used these so am a bit unsure.
Please see attached a copy of the DB and an example of what the estimate would ideally look like.
If this is a big change then we'll carry on as we are but if it is possible it would make more sense to do it properly.
As ever, any help greatly appreciated.
Thank you
I have very limited knowledge of Access and have basically taught myself (not that well!) to set up various forms/reports etc and this is my latest task.
I have managed to set up tables, a form and reports and it works quite well for what we need. However, the estimator has come to me with a problem which is above my remit i think...
My form only allows 1 cost per estimate, however, there are instances when multiple items need to be entered. We have got round this so far by exporting to a rich text Word file and amending manually, however, this isn't really ideal as if you search for the estimate on the DB it only brings up the original.
Is there anyway I could adapt what I already have to enter multiple lines on one estimate number? Not sure if it's something I should be using a sub form for but I've never used these so am a bit unsure.
Please see attached a copy of the DB and an example of what the estimate would ideally look like.
If this is a big change then we'll carry on as we are but if it is possible it would make more sense to do it properly.
As ever, any help greatly appreciated.
Thank you