Portal or script - or both?

[cergos]

Hi,

I would like to have a database where a drop down list will auto open a corresponding drop down list. EG list A will have a selection of product types - by clicking on a product type, list B will show the products contained within that product type (list A)

By clicking on the product in list B, a complete description will appear in a fields layout.

So ... product group (from List A) = soft drinks (soda)

List B shows 20 sodas - by selecting soda 4, the fields propagate with the information for soda 4 (eg supplier, contact name, telephone, email etc)

Is there a quick, simple and user friendly way of doing this?

many thanks

[jasonwood]

Create the first value list the regular way.

Then create a relationship to a new database "Product Types", which has a productType field and a products field.

Create a record in this database for every product type, then enter the products (separated by carriage returns) in the "products" field.

You will relate the first popup field "ProductType" in your main database to the "ProductType" field in that new database.

Now you want the second popup to be based on a value list which is "conditional" (ie: it depends on the value in the first field).

For the second popup list, define the value list as follows... "Use values from field", and choose the option "Only related values"

The field you select will be "products" from the new database you created.

Hope that makes sense!

[cergos]

Thanks Jason

I'm on it! Will advise.

ps Your 'bug' looks great!

[cergos]

I have created 2 files

Category

Product

In Cat file I have 2 fields - category (popup list) in which I have 2 entries as a test - soda and chocolate and products (from Products file)

In Product file I have 2 fields - category (from Cat file) and products (popup list) in which I have 4 entries - Coke, Pepsi, Milk, Dark

I can't seem to link them so that if I select soda from popup list in Cat file, then the second field gives me 2 option (ie Coke, Pepsi)

Any ideas?

thanks

[cergos]

Got it .... thanks Jason

Happy New Year !!!

[jasonwood]

wow that was an easy answer!

Glad I could help

BTW this is called a "Conditional Value List".