Odd search forn setup, pulldowns involved.

[ddean68]

I am currently making a databse for troubleshooting purposes. What I have are 3 tables.

keywords = symptoms of issues
key_solve = link between tables
solution = the solution of course (memo field here)

What I am attempting to do is make a form that has 3 pulldowns. All 3 will use the keyword table for the values. I wish to have the list of solutions narrow as keywords are selected.

Any suggestions would be appreciated.

 

[WayneRyan]

ddean,

What you are describing are cascading combo boxes. Could
you elaborate a little more on your table structure?

Wayne