Intial Setup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am starting a database to track an Avaya phone information data. I am
wanting to be able to track the skills assigned to a rep. Some reps have 1
skill, some have up to 7. I'm interested in creating a form that will allow
me to intially input the data and then to be able to access that reps records
and up them as their skills change. Would that best be addressed in the
table format or just in the input Form or is it done in conjunction with
Queries?
 
Not sure If I understand this but I will give it a go:

set up a rep table with just the rep information.

Then you set up a skill table with just the available skills.

Then you set up a rep skill table that will be store the skills that
each rep will actually have.

You can have a form that represents the rep and a subform that
represents the reps current skill. The subform can be a simple
datasheet.

Each of the subjects I am talking about are easily referenced.

Now, if I understand your question correctly, you are addressing some
pretty basic relational design issues and you will benifit from just
about any beginner book on designing Access applications.
 
Back
Top