Cascading Combobox Rev

Project Description: Have a combobox that pulls field name from a materialbycustomer table. Once the customer name is chosen, need to use that info to get to a pulldown from customer materials, then use a button to put both the data from the first combobox (customername) and the second combobox (materialname) into another table. This is a subset of a much larger project with just the key elements stripped out. Feel free to write out the code in VB, just make proper notations.