Okay QBCoach,
I think your approach is the way to go but having some difficulty executing. I created the relationship between to have one Company Type to many Companies. Within the settings of the Company Type table I can create reports and filter on Company Type to see only the types I want to see. Now I create another table to contain the special info I want to capture. Now I move to the form/table for the special info I'm storing. I open that form and select the Company Name , I can't seem to find where I select the report that filters just the Company Types I want to see. For that matter, don't see where I can assign a report to a drop-down list at all - only see where to assign a field source.
