Drop Downs Auto Populate..............

[Guest]

Hi Everyone!

I thought I had posted this Q last week but I can't find it in the list so
must have forgot!!!!

I want to be able to fiilter the contents of a list box based on a selection
from another list box, both getting there data from a DB. Does anyone know
any tricks to acheive this?

Example

When a user selects colour blue in drop list 1 drop list automatically
updates with items with colour blue etc.....................................

Does that make sense?

Tia

Jonathan

 

[Guest]

Sorry the Example should have been: -

When a user selects colour blue in drop list 1 drop list 2 automatically
updates with items with colour blue as a catagory
etc.....................................

 

[Guest]

I have solved it with a little help from the Spiderwoman (Thanks Kathleen)

But now I can't submit my final values to the DB I get a message in the
browser liek this: -


Cannot save value to database field

But it don't help because it isn't telling me which field is causing the
problem, Any ideas?