combo box, how to limit to client table

[bml337 via AccessMonster.com]

I have the following tables: CLIENT, EMPLOYEE, OFFICE LOCATION. I have a one
to many relationship with the client> employee and client>office location.

Now i can associate all the clients employees as well as the clients
locations. On my employee form i would like to have a drop down box that
shows all the clients office locations. so i can specify which office the
employee is located.

think i have to run a query, then limit the list to the client ID???? am i on
the right track??? help thaks.

bl

 

[Guest]

You just need a query that limits the office locations list to the current
client to use as the row source of your combo box.

Assuming you have a control on your form that has the ClientID in it named
(for example purposes) txtClientID (Use your own names)

It would be SELECT OfficeID FROM [OFFICE LOCATIONS] WHERE [CLIENT] =
Me.txtClientID;