Queries to lookup a value

P

Paul

I have a situation where what I want to do is:

Combo Box one [Field 1] shows all the options e.g.: (Fruit, Meat, Breaed)
Combo Box two [Field 2] shows all the options that have been limited by
[Field One] e.g.: (Apples, Pears, Oranges)
Combo Box three [Field 3] shows all the options that remain after filtering
by Field1 and Field2

Once I have that I want to have a form field that Looks up [Field4] and puts
it in that form field.

This is to be able to say give me fruit, apples, fuji, and then put in the
unit price field the correct cost.

I could really use help on this!!!

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top