I've seen this posted before, but can't seem to find it.
I have a table that has size and price info. Example:
ID Size Price
1 S 10.00
2 L 11.00
3 XL 12.00
4 XXL 13.00
I do a db call to load a dropdown. I would like to display the size
in the dropdown and insert BOTH the size and the price from the
dropdown.
I realize I could do a search on the ID before the insert and then
insert from the results, but is there a slicker way of doing this
with just an insert?
Thanks!
--
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body