I am building a database for a car dealer, and I need to build a way for users to select 1. Make, 2. Model so they can narrow down a list of cars. So for example, if there are 3 Acuras (TL, RL, MDX), and 2 Fords (Explorer, Taurus) in inventory, then the drop down for the Make would only show the values [Acura, Ford]. If the user selects Acura, I'd like the model drop down to show values [TL, RL, MDX].

Is there a simple and elegant way to build this so that I'm not jumping from one page to another? I know I can build jump fields that redirect to a 2nd page so the model is filtered on the make value, but I am trying to do this on one page without any delay on the browser. I've seen other sites do this, and they must be building a dynamic array in memory or something???

Thanks in advance.