Please help.... I have created a databse with five tables (A,B,C,D and E). Table A is the Product Type list and Table B, C and D are tables containing differnt type of Products. Table E is the table that I want to store the transactions. Table E will be populated via a user form. The fields in Table E are Date, Product Type, Product and Quantity. In the user form is it possible to select Product Type (from Combo List of Table A) and that will only show the Products (from Table B,C and D). For eg. one of the product type is microphones and Table B is the list of all microphones. Is it possible, that when I select Microphone from the drop down menu then the Product list only shows me the list of the microphones. This is similar to the dependant list in Excel.