I am putting a page together to capture sales info for a small company. They sell cars to auctions, dealers and retail customers.

If they choose 'retail' in the sale type field, I'd like to display a drop down field next to it showing a list of customer names (values from a recordset).

If they choose any other sale type, then I'd like for the customer field to remain hidden and write a null value to the db.

Any ideas on how I can make this happen? I'm programming this in VBScript/ASP.
Thank you.