This topic is locked

Using drop down's to select data

4/17/2004 8:41:51 PM
ASPRunnerPro General questions
J
jmawebco author

I am trying to use data from one table when adding a new record to another table. What I want to know is if there is a way to add a drop down list on the add new record page so an item can be selected instead of having to type it.
Any help would be appreciated!!!

Pete M 4/18/2004

Hi,
On formatting (step 9) for the field you want, select 'lookup wizard' from the 'Edit As' box. Then click 'change' in the 'Edit Format' box. This lets you type in a static list, or select a table for the lookup.
Hope that helps
Pete

J
jmawebco author 4/18/2004

Thanks, That's exactly what I needed.
Jaime