Trouble with LookUp

[glinch]

Hi there, hopefully somebody could help me here


(Access 2007, Win XP)

Briefly, I have three tables as part of an overall database; Organisation-tbl -> Office-tbl -> Agent-tbl

An organisation can have many offices, and thus many employees/agent, pretty straightforward. I have info on the various organisations and their offices already entered.

I am designing the agent Table and would like to be able to do the following

When adding an agent, Select there organisation, easy enough to do - Look up from Organisation-tbl.ID - so far so good

After the organisation is picked, I would like to be able to select from the relevant offices for that organisation.

How do organise the table/queries to do so

If any one can point me in the right direction it would be greatly appreciated

Cheers

Noel

[RuralGuy]

That is just cascading ComboBoxes. A Google search will turn up lots of references.

[glinch]

Thanks alot, exactly what I was after

[RuralGuy]

The link in my sig shows you how to mark this thread as Solved.

[glinch]

got you, cheers

[RuralGuy]

Thank you.

[RuralGuy]

Darn...I forgot to welcome you to this forum. Where are my manners? Welcome, welcome, welcome.