I created the view using the view designer. I figured the combobox in the txtbtns search class was getting it's field list from the One table, but I wanted the capability of searching fields from both the one and the many tables. I made a view for the One table with fields for the many table included but it includes all the records from the many table as well. I want only one record for that view but I'm not sure how to do parameterized views. I'm a brand new member here... looks like a great resource.