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