This topic is locked

Dependent drop down list with multiple tables

12/21/2006 2:52:37 PM
ASPRunnerPro General questions
H
haggecha author

I have three tables
Product Table

Product ID

Product Name
linked to a Basline table

Baseline ID

Baseline Name

Product ID
linked to a Review Table

Baseline ID

Review ID

Review Descr

Etc......
I currently have users select a product, a baseline, then add a record with the baseline ID poplulated, I would like to have dependent drop downs on the add review page to select the product and then baseline (instead of navigating through three screen, using the master relationships) , but the productID is not part of the review record, is this possible.
Chad

Sergey Kornilov admin 12/22/2006

Chad,
you cannot create a dropdown box on the top of field that don't exist in this table.