open a form and select a value from it to enter into a form..

[Maclain]

Good morning all.

We have a database where we are trying to limit the amount of data that users need to input.

We have a form, which contains order information. Where a customer has specific requirements, we add those requirements to a separate document review table MasterSpecification and DetailedSpecification.

When a customer has specific requirements, we can open the frmMasterSpecification and search for the document. Assuming a review has been done the requirements will be shown on the subform Frmsubcoverage. I would like to be able to select the record source from this form and have the details entered into our order entry form.

Under the specification form there could be many sub coverage records depending on the type of item ordered to that specification.

My coding is not Yoda, so examples and explanations are greatly received!

TIA

Chris.

 

[burrina]

This seems odd to me, why not simply set the "Status" to whatever you need? Also, if you need to populate a subform, simply link it to the Main form! Or are you wanting to duplicate the information onto another form?

 

[Maclain]

Hi and thanks for the reply.

Yes, I need to duplicate the information.

We review a standard, and create an entry for it in the standards table. the standards detail table contains the variables depending on what the customer orders.

The orders table is where the order processing is done, and part of that is to select the correct requirements from the standards table. I would have thought opening the standards form and selecting the correct requirements to copy across to the orders table would be the best way to go, but I'm open to suggestions.

I should point out that the standards table will become incredibly large over time.

 

[burrina]

So, you are duplicating info from one table to another? Is this correct?

 

[Maclain]

Hmm.. yes, but that's not entirely essential.

 

[burrina]

Duplicating Data is ALWAYS a bad db design flaw! NOT essential? Please explain! Hard to understand what you are doing.

 

[Maclain]

Indeed the design is flawed, but we have to work with it. We've solved the issue by using an append query.

Thanks for your response.