third time lucky :-)

[Andy]

Table Name: Price
Fields: Id (autonumber) UserID (number) ProductID (number) Price (currency)

How do i insert all of the productID's from a dropdown menu into the Price
table.
I also need to insert the UserID (from a session variable) at the same time.
The Price field has a default value and can be ignored.

I'm using acess 2000 & classic asp.

Andy

[Nancy Gill]

> How do i insert all of the productID's from a dropdown menu into the
Price

> table.

On your insert form, use the list/menu item in place of a text field ..
populate that from a recordset that has ProductID's as values and Product
Names as labels.

> I also need to insert the UserID (from a session variable) at the same

time.

> The Price field has a default value and can be ignored.

Create a hidden field within the form label it Session_User (or whatever)
and use the Session Variable object to populate it.


--
Nancy Gill
Team Macromedia Volunteer for Dreamweaver MX/UltraDev
[url]http://www.macromedia.com/go/team/[/url]
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development