HI... can anyone help with this mini thing I'm doing. I've got a form, from which user can choose a product from a recordset. That recordset contains the product name, and it's price. What I want to happen is whatever product the user has chosen, when the record is inserted to the database, the product name and price are submitted. So basically I just need to tie the two fields together somehow, so like the recordset is

productid
productname
productvalue

and in the form they put

name [namefield]
email [emailfield]
product [drop down field containing recordset productname]

which inserts into a new table detailing

name [namefield]
email [emailfield]
product [productname]
productvalue [productvalue]

Could I do this by having the product recordset and the submitted data recordset on the next page, and use the 'move to specific record' behaviour so the displayed data matches the ID of the product chosen?

USing DMX with Access XP

Any help greatly appreciated!

Cheers Rich...<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>


Party On!

Rich...<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>