use field lookup for abbrivation

[car20]

Hello

I create one db in access 2003 .

I have 3 field company , plant and flowmeter in main table .
company A with 3 plant Plant A1 ,Plant A2 and Plant A3
company B with 3 plant Plant B1 ,Plant B2 and Plant B3
company C with 3 plant Plant C1 ,Plant C2 and Plant C3

for company and plant I created 2 tables (company and plant )

in main table for company field ( lookup Tab ) choose combo box and select company field from company table .

in main table for plant field (look up Tab ) choose combo box and select plant plant field from plant table .

Now I have one problem :

I want when choose company A in field1 I see plant A1 , plant A2 and plant A3 in plant field Not all plants .

that means with select one item in first field Decrease items in next field .

sorry for bad language.
please see attach file .

thanks

 

[jzwp22]

I'm not sure I completely understand the issue, but you database is not structured properly. If a company can have many plants that describes a one(company)-to-many(plants) relationship which is represented with 2 related tables. I have removed you main table and modified the two remaining tables to form the proper relationship. I included an example form with a subform which is how you would represent the relationship. I also included an example query. The modified database is attached.

Also, it is not a good idea to have combo/list boxes at the table level. Please see this site for more information.

You may also want to read up on the rules of normalization which govern proper table structure design. You may also want to check out Crystal's site for some tutorials on how to get started with Access.

 

[car20]

Thanks jzwp22 ,

Mayby I bad explaind problem .
I have 3 company with 9 plant ( each company 3 plant)
I want when choose company A as company field in form , display just 3 plant not 9 plant (company A plants).

I hope to be able to explain the problem.

 

[John Big Booty]

Sound's like you are looking for a Cascading Combo Box set.

 

[car20]

Exactly , Thanks so much John Big Booty.

very Goooood