Limiting combo box values depending on results of other combo box entries (1 Viewer)

[whitespace]

Hello all,

I'm developing a staff database and have a number of tables e.g.: tlkDepartment, tlkGroup, tlkTeam and tlkLocation.

I've got a form that correctly lets the user select from these and then store the ID in the tblPost table.

However what I would like is if they select say Department "SSGF", this limits the tlkGroup records to those that are associated with that Department, similarly - when the user selects the Group, it limits the entries available in the Team field, and then that limits the values in the Location field?

Does this make sense and is this easy to do or the right way to do this?

Many thanks for any help.

Jenny

 

[neileg]

Do a search for cascading combos in these forums.

 

[twoplustwo]

http://www.fontstuff.com/access/acctut10.htm

I learnt the most from the above link.

 

[whitespace]

thanks a lot twoplustwo, that's just what I needed.