URGENT: reaching deadline....Linking Pull down contents to value in other field

[Fozi]

I have a form where the user enters the name of the Company. I then have a control where they enter a contact for that company.

How can I set it up so that the contact list is limited to those against that company and not and entire list of all contact in my table?

Any help is much appreciated.

Thanks

 

[namliam]

Have a search at "cascading combobox" and see how far you get.