Using a fields drop down selection to populate 2nd fields drop dow

[FigoEMT]

Hi, I've been searching over the forums for the past hour and I cant seem to
find what may help solve my problem, hopefully its not redundant:

Goal:
In a Query, have field 1, and its chosen value from its drop down list,
populate a second field next to it, and the 2nd fileds drop down list values.


Set up:
I have a table full of vendors names, and info.

I have a second table full of fields for invoice data, (i.e field 1 is a
drop down of vendors, field 2 is a drop down of PO's from a PO table, Field 3
is the invoice total, etc...) and all respective relationships are a
one-to-many cascading update this table for the Vendors and PO's.

I have a third table that shows all the Vendors, and their assigned PO's, in
two seperate fields, called the PO table (how original ). Only
Relationship to this table is from the Vendors Table, which is a one-to-many
cascade updates into the vendors field in this table, as i will update
vendors and add new ones, etc... PO field is entry only.

Now I have a query from the Invoice table.

If I choose Vendor C, in field 1 ("Vendors"), which is a drop down, I am
trying to get Field 2 "Associated PO" (also a drop down list of PO's from the
PO table) to only show the PO's from Vendor C, as that was the chosen in
Field 1. Kind of a quasi filter i guess.

Any Ideas? Do i have this all wrong? Thank you so much for taking the time
to read this!

 

[Conan Kelly]

FigoEMT,

Off hand, I don't know for sure if this is possible in a query (maybe
someone else here know if/how to do that). But I know it can be done in a
form (if you are using forms). I have successfully set this up once, but it
has been a long time and I don't have it here at work.

If you are interested in going this route, let me dig up the DB at home and
review it and I can help you.

Let me know,

Conan