I am trying to create an invoice that has two drop down lists. One is the
Category eg.(audio, video, misc) once I pick one of those the second dropdown
list shows only products related to that category. I would like to choose a
product and have it fill out the price for that product. So it goes category
then description of product and finally price. How would I go about creating
that?

thanks!