Looking up data in Access 2000

[Jennifer Portnick]

Hello-

I'm quite new to working with Access (as this message may give away).
I've created a simple database for my company with the following
tables:

1. Store location number, store name and store address;
2. Staff assignments by store (names of support personnel assigned to
each store location).

I have created relationships between these two tables based on store
number and my query will pull a datasheet listing staff for each store.
What I'd also like to do, though, is have a form in which if I put a
store name, the store number, name, address, and staff assigned come
up. I think this is done using a combo box but for the life of me I
can't figure out how to do it. Can anyone offer some guidance?

Thanks-
Jennifer P.
San Francisco, CA

 

[Jeff Boyce]

Jennifer

From your description (one-to-many, store-to-employees), you could use a
mainform/subform construction. Your main form could use a combo box to let
you pick a store, then display that store's data. The subform would be
"fed" by a list of employees, including their StoreID (which store(s) they
work at).

When you add (in form design mode) the subform into the mainform, Access
prompts for the parent-child fields. I'm guessing that's StoreID?!

Best of luck on your project.

 

[Jennifer Portnick]

I'll give this a try. Thank you very much for your response.