Maybe too complicate

[Tom]

Hi All,

I`m creating a DB for a florist.
He has many flowers and many vendors, I need to create a form that will be
the cratiria for a search.
first field is the flower, second field is the vendor, both fields are combo
box.

I have 3 tables: flowers, vendors, transactions.
the last one recording: date, vendor, price and flower.

When I choose a flower on the first field of the form, the list for the
second field will be narrowed to only those vendors who sell this flower.

of course, those vandors have to have only one apparance on the list.


Thank you in advance,

Tom

 

[Guest]

Search on Cascading ComboBox.

 

[Tom]

Hi Karl,

Thank you for the quick response.

Can you provide more info regurding cascade search?
How do I do it?

Thanks,
Tom

 

[Douglas J Steele]

Did you search for Cascading ComboBox, as Karl suggested?

http://office.microsoft.com/en-us/assistance/HA011730581033.aspx is one
resource.

 

[Tom]

Thank you very much, I`ll look into it.

Did you search for Cascading ComboBox, as Karl suggested?

http://office.microsoft.com/en-us/assistance/HA011730581033.aspx is one
resource.