Please Help Me

[Dopeyjh]

Hi,

I am in need of some serious help with my database.

I have two tables created, lets say one is Name and the other is Company

In a form for "Name" i am trying to create a feature that will allow me in a drop down box select a "Company" and also bring another two more fields from the "Company" table onto my form for "Name". What i want to do, is while i am looking at a customer in "Name" i want to be able to select from a drop down list of the "Company" they work with and all see the status of that "company" and their system code.

I hope that i have explained it ok...

Anyone have any ideas???

 

[RuralGuy]

Start yourself off right by not using reserved words for *anything* you define.
Problem names and reserved words in Access
Then I would ask if you can base your form on a query that joins the two tables?

 

[Dopeyjh]

Sorry, actually that was my typing error, i wasn't using those as reserved words, just trying to explain my situation. I am familiar with access although not 100% up on the lingo
In anycase, here's what i am trying to do. I have two tables, one is Agent and the other is Company. In my Agent form i have a combo box that selects the company name from my Company table and inputs the Company name in the Agent table. What i would like it to do, is look up the status of that Company that is selected and input the status from the Company table into the Company Status field on my Agent Form.

I hope that i have explained it better...

Any help is appreciated.

Thanks.

 

[RuralGuy]

Hopefully you are putting the CompanyID in the Agent table and not the CompanyName. You would then be able to create a query that joins the Agent table and the Company table on the CompanyID field. Then you can base your form on that query and include the Company Status as a field in your query.