best practices - using one form to submit multiple records

[frdnwr]

Hello all,
my tables are :
products : category,name
brands: name
sizes: name, weight
prices : date,product.name*brand.name*size.name, value

I have like 5 combinations of products .. so I want the user to be able to daily update prices on all products from one form .. by entering the new price in front of the related product. this form should update the prices table ..

is this a correct way to achieve the result ?
and how can I create a form that updates several records at once ?




Thanks to you all .

[June7]

Why would several records need to be updated with the same value? It can be done with an SQL UPDATE action by specifying criteria to match records that require the update.

[frdnwr]

it's not the same value .. except for the date .. like , we update price of 5 different products everyday ..

[frdnwr]

Well, I'e checked the SQL Update statement, this is exactly what I wanted to learn, thank you very much .

So now I'll create a new blank form, and put the code to insert new values ( sorry I mistakenly used the term "update" ).