Basing A field on another field

[David S. Zuza]

OK, I will try to explain.

I have 3 tables

tblPersonnel
--------------
ID(Autonumber) (Primary Key)
Lname(text)
Fname(text)
Division(text)
Shop(text)

tblDivsion
----------
ID(Autonumber)(Primary Key)
DivID(text)
Division (text)

tblWorkcenter
--------------
ID(Autonumber)(Primary Key)
Div(Number) ( Linked to ID on tblDivision )
WorkCenter(text)

What I want is to be able to have it so that on the tblPersonnel when I
select a division from a combo box. it will populate the workcenter field
with only the workcenters that belong to that division... I know this has to
be very simple, but for that life of me I cannot figure it out...


HELP Please.

thanx

 

[Allen Browne]

Use the AfterUpdate event of the first combo to set the RowSource of the
second.

Details in:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm