How to query dynamic field generated on a form in a combo box

[bhuffer]

I have 2 tables (Software_Titles and ITInventory). The software table has (ID, and Title) and the IT Table as (PCID, PCName, 30 some odd software titles in yes/no configuration). Probably not the best setup, but it's what I have. From a "switchboard", I need the ability for users to select a "software" title from a combo box (sourced by Software_Titles table) and find each record in the ITInventory table where a value of True is marked for that particular software title.


Make sense?

[Robeen]

Where/How do you want the records displayed? In a separate Form . . . perhaps?