Very New/How to Create

[John_G2112]

Hello Everyone,



I'm very new to this forum so i wasn't sure wher ei should post my inquiry. I have a project i'd like to do and i believe that Access is the best way for me to go about doing it, problem is i don't know access very well. If i could get some general direction and whether this is the ocrrect path then i can probably take it from there. Thanks all....

Here's my idea/project

I currently work for a commpany that owns 90+ stores. Each store has a constantly changing managers, designers, etc. Right now i have multiple sheets of paper that come out listing the store and then 1 page for manager, 1 page for interior designers, etc etc. What i would like to do is to make a form of sorts where i could first pick the store i want and then have it list all my appropiate managers/designers and such. I would need some "master lists" and then i'm guessing that each field in the form would perform a query depending on the store i pick from the original drop down.

I really hope this makes sence and that i'm in the right place.

Any help, comments, and suggestions would be greatly appreciated.

Thanks everyone, i look forward to yoru responces and building this tool

John G.

[pbaldy]

Does this sound like what you're looking for?

http://www.baldyweb.com/CascadingCombo.htm

[orange]

A company that owns 90+ stores, and continues to profitable today has to have some automation to support that business.
They will have some sort of IT section/person/people.

Where do you fit in this organization?
Are Managers/others complaining?
Has anyone approached a) management or b) the IT section?

Before you "solve" a problem, make sure it's really a "problem".

[John_G2112]

pbaldy, that is very close, but even easier. When you pick a state in your example then the "capitol" would fill out automatically. One field that's a variable (state) and then multiple fields that just fill out automatically based on the state ( capital, population, time zone, etc)

[pbaldy]

Like this?

BaldyWeb - Autofill