Macro using Drop Downs to Select Table

[Mkauley]

I have built a series of tables in my database, one for each person on my
sales team. I want to have a macro set up so that I open a form with a drop
down of all their names. They select the name and click a button. The
button is linked to a macro that uses conditions. I'm having troubles
setting up the macro so that it opens a related table based on the person's
name. Any ideas?

 

[Steve Schapel]

Mkauley,

There are two problems here.

First of all, the purpose of tables is data storage. General wisdom on
the subject is that they should be in the background at all times, and
not accessible to the database user except for the design and de-bugging
stages of database development. If you are opening a table for the
purpose of viewing, entering, or editing data, you would be better off
using a form.

Secondly, and probably more seriously, having a separate table for each
sales person would be regarded as an invalid design. I would urge you
to review this structure. You will find many people in these forums who
would be willing to assist and advise.