Problem with underlying tables

[ember]

hi everyone, i need your help with something here:

i have three tables, Order, Supplier, and Supplier Contacts.

What i need to do is, when I create an Order in the order tables, be
able to fill the supplier and supplier contacts by using underlying
tables, being that the Supplier Contacts table is related to the
supplier table, when i fill the "supplier" field in the Order table it
only allows me to use one record from the Supplier Contacts table. what
should i do so i can, in the Order table, fill in the Supplier field
and then the Contacts field with the contacts that belong to the
Supplier i filled in previously?

i.e.:
Company X -> John Doe; Jane Doe
Company A -> James Bond, Mary Williams

I want to be able to, if i put "Company X" in the Supplier Field, in
the Contacts field in the combo box appear "John Doe" and "Jane Doe"
only, so I can choose one of them.



Thanks in Advance,

Ember

 

[ember]

Isn't there anyone where who can help me??!!?

 

[BruceM]

Sometimes the reason you don't get an answer is that the question is
unclear. Remember that we can't see your database, so you need to be clear
about just what you need. Are you filling orders for your customers, or are
you placing orders? How are your tables related? How does "the supplier I
used previously" fit into this? Previous to what? Are you using forms for
data entry?
I would suggest that you start a new thread, providing some details based on
my questions in the preceding paragraph. You should explain your table
structure and relationships, then explain that when you select a supplier,
who could have any number of contacts, you need to be able to select a
single name from the supplier's contact list for that order (or whatever
exactly you need to do).