>
> > I like to be able to choose the values from a LookupComboBox that
> > should depend on the value os another field that is informed
> > previously. Any suggestions?
>
> More information is needed. Please explain what you are trying to do
> in more detail.

OK. I'll try to do it:

I have a table called TICKET which has a field called excursion which is get
from the EXCURSION table using a LookupComboBox. There is also a field
called hotel in the ticket table which I'd like to inform using a
LookupComboBox from the HOTEL table. But I don't want to show all the
records in the HOTEL table, just the ones that have a field (zone) equal as
the field in the EXCURSION table.

So the database structure is

TICKET
idTicket Numeric(10,0)
excursion Numeric(10,0)
hotel Numeric(10,0)
....

HOTEL
idHotel Numeric(10,0)
code Varchar(8)
description Varchar(30)
....
zone Numeric(10,0)

EXCURSION
idExcursion Numeric(10,0)
code Varchar(8)
description Varchar(30)
....
zone Numeric(10,0)


ZONE
idZone Numeric(10,0)
code Varchar(8)
description Varchar(30)

One chosen an excursion I have to choose a hotel but it has to be a hotel in
the same zone as the excursion zone.

Greetings

Toni