The attached spreadsheet has been imported into access as a table called qv_categories. I created a form that a user must select which section between compliance or procedural, then the next field "category" would be prefilled in a combobox with categories tied to the section chosed. The same would go for the subcategory. Once the user selects all three fields, the data should be updated into the qv_category table. My issue is that there are multiple rows for the compliance and procedural sections. So when I create a combo box from the table, there are 16 rows in the combo box with multiple compliance and procedural records. How can I limit this two just one compliance and one procedural, then have another combobox updated with the corresponding category from either on chosen.