filtered drop down list

[mikej28621]

I have 2 tables. Table1 contains software types and versions, example

Office 97
Office 2000

Table2 contains a software inventory. One of the columns is a drop down list box that contains unique software types from table 1.

I want anouther column that is a drop down list box that contains version information from table1 filtered on the software type field in the same record. Is this possible?

Thanks in advance.

 

[PHV]

Take a look in the FAQ area of the Access Forms forum.
An entire section is devoted to combo.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[mikej28621]

Thanks PHV,

I had look thru there and did not see anything relavent (unless I just missed it). I also did some searching on the net.

I guess there are 2 things that make this unique. I want to use a list box in a table view not on a form and I want to make a second (query) list box out of the value of a field in the same record.

Thanks

 

[PHV]

Sorry, misunderstood your issue.