Form for Data Entry

[cherkey]

Hello,
I'm trying to use a form for data entry with a product, then several options for that product. Tables are products, standards, and ProductsandStandards. In the form I'm trying to set it up so that I enter the product name, then several combo boxes for the standards. Trying to figure out how to hold this data, so that when I click my button for done entering data, all this info gets placed into the ProductsandStandards table. Thoughts?
TIA


cherkey

[alansidman]

If your form is bound to a table, then when you close the form or move to a new record the table is automatically updated.

If you are using an unbound form, then you will need to do something like this:

http://www.datapigtechnologies.com/f...rdsnocode.html

Alan

[cherkey]

Thank you, this really helped moving me in the right direction. However, I have several options (standards) from the same table that will apply to the same product, so several combo boxes on the form. The append query (and the table being appended to) then would have to have multiple columns for each of these standards. I don't think this would work should I ever have to add new standards. Is there a way that after selecting the standards from the several combo boxes, the data would be entered into the table in a columnized fashion?
Product Standard
Tester stdoption
Tester stdoption48
Tester stdoption53
etc
As opposed to:
Product Standard1 Standard2 Standard3 ...etc.
Tester stdoption stdoption48 stdoption53

TIA
cherkey

[alansidman]

Sounds to me that you have a non normalized database. Look at this on how your database should be setup. A non normalized data base will always require workarounds and cause you lots of issues.

http://forums.aspfree.com/microsoft-...es-208217.html

Alan

[cherkey]

<sigh> I set up the tables this way because I thought my first attempt was non normalized.... I'll check that link. Thx.