Hi,

This is my problem. I must create four combo boxes to display unique data
(from numerous duplicate entries), where the data displayed is dependant upon
the previous combo box. An example of data may be:

Class Category Sub-Cat Type
Joe Truck Lease 2007
Joe Van Rent 2005
Joe Van Sale 2008
Pete Car Sale 2004
Pete Truck Lease 2008
Pete Truck Rent 2004
Pete Van Sale 2006
David SUV Lease 2007
David Van Rent 2007
Jenny Truck Rent 2005
Jenny Car Lease 2001
Jenny Car Sale 2008
Niel SUV Sale 2004


I select JOE - then a choice of TRUCK or VAN, then if TRUCK, - LEASE -
2007, or if I selected VAN, - RENT or LEASE or SALE, and the appropriate
year respectively in the last combo list. I've gotten sooooo complicated,
with one problem being the blanks between unique entries, once I've
eliminated the duplicates. How do I get to shorten the lists to actual data
only?

My apologies for the questions. I have searched the forum extensively, and I
believe I need a hybrid solution, which is currently beyond my means and
imagination!

Thanks in advance for any help.

Nemo