Hello, I have an issue with a new database I'm trying to create (attached). I have two tables. One called Quote Number Summary, and One called Quote Data. The only purpose of the Quote Number Summary is to roll up quotes with the same number. I have a few quotes that share the same quote number and I wanted to created a form that only shows 1 header with all the quotes that share that number below. So if there are two number 1 quotes I only have one header on the form, but 2 entries in the subform. At first glance it seems to work until I try to enter a new quote number using the Quotation form which isn't on the Quote Number Summary table. I get the Error " You can't add or change a record because a related record in Quote number summary is required".
In reality I only want the one table for the data, but a form that will show the summary. I've tried a few different methods, but without this extra table I can't seem to get it to work.
I've attached the database with some sample info for you to look at. If possible I just want the people using the database to use the Quotation form to input data and for it to be included in the summary form with header and quote history. Unfortunately we have to have it summarised by quote number and not customer which doesnt help me.
Thanks again for any help you can give.
In reality I only want the one table for the data, but a form that will show the summary. I've tried a few different methods, but without this extra table I can't seem to get it to work.
I've attached the database with some sample info for you to look at. If possible I just want the people using the database to use the Quotation form to input data and for it to be included in the summary form with header and quote history. Unfortunately we have to have it summarised by quote number and not customer which doesnt help me.
Thanks again for any help you can give.