How to update multi select fields from form to table or reports

[kimb]

I have seen several posts on this particular subject, but I haven't really
found an answer to my problem. I do not consider myself to be an advanced
user of Access, but I know enough to get me into trouble.

I have been asked to create a database to store employee information. The
tables I have are: Main table, Employee names, Account names, Tasks, Backup
and Trained The person requesting this database wants a form, which contains
subforms for Backup and Trained. Their idea is that the form will link to the
main records which contain the Account Name, Task, etc, while the 2 subforms
link to the Backup and Trained tables. The Backup and Trained tables contain
the Employee names. They want to be able to multi select employee names under
the backup subform and the trained subform. This information is to be updated
to the main table(which from what I read seems to not be possible). I'm not
sure how to "store" this information. The end result I need is to be be able
to create/run reports which contain the Record #, Account name, Task, etc,
and then all the employess that are considered a "backup" and all the
employees that are considered "trained" for the particular Record #.

This, by the way, was originally an Excel spreadsheet, but "they" want it
converted to an Access database.
Any ideas or help would be greatly appreciated!

 

[KARL DEWEY]

What data is contained in the Backup and Trained tables other than the
Employee names?
Does the data susposed to show who can backup who?
What does Trained table do for you?

 

[kimb via AccessMonster.com]

Karl, Sorry for the late reply. The Backup and Trained tables are employee
names. The Backup table is to be used to select which employess are the
"backups" for particular accounts. (There are 25 accounts) When the primary
person that handles the particular account is out for the day, or on vacation,
this table is to show which person will "cover" that account for that day.
The Trained table is to show which employees are "trained" on which accounts.
These employees are not necessarily the "backup" people. The person who is
wanting this database I believe, wants to make sure everyone is cross-trained
and I think this is why they want this "trained" table.

Thanks for your help!

What data is contained in the Backup and Trained tables other than the
Employee names?
Does the data susposed to show who can backup who?
What does Trained table do for you?

I have seen several posts on this particular subject, but I haven't really
found an answer to my problem. I do not consider myself to be an advanced

[quoted text clipped - 17 lines]

converted to an Access database.
Any ideas or help would be greatly appreciated!

 

[KARL DEWEY]

Use three tables in one-to-many relations. Then use form/subform to view
employee/account qualification or account/employee.
Employee ---
EmpID – autonumber – primary key
LName – text
FName – text
MI – text
Phone – text
Etc.

Accounts ---
AccountID - autonumber – primary key
AccountNUM – text
Name
Etc.

Qualifications ---
QualID - autonumber – primary key
EmpID – number – integer – foreign key
AccountID - number – integer – foreign key
Level – text – Trained, Backup, etc.

--
KARL DEWEY
Build a little - Test a little

Karl, Sorry for the late reply. The Backup and Trained tables are employee
names. The Backup table is to be used to select which employess are the
"backups" for particular accounts. (There are 25 accounts) When the primary
person that handles the particular account is out for the day, or on vacation,
this table is to show which person will "cover" that account for that day.
The Trained table is to show which employees are "trained" on which accounts.
These employees are not necessarily the "backup" people. The person who is
wanting this database I believe, wants to make sure everyone is cross-trained
and I think this is why they want this "trained" table.

Thanks for your help!

What data is contained in the Backup and Trained tables other than the
Employee names?
Does the data susposed to show who can backup who?
What does Trained table do for you?

I have seen several posts on this particular subject, but I haven't really
found an answer to my problem. I do not consider myself to be an advanced

[quoted text clipped - 17 lines]

converted to an Access database.
Any ideas or help would be greatly appreciated!

 

[kimb via AccessMonster.com]

Thanks for your help! I will give this a try.

Use three tables in one-to-many relations. Then use form/subform to view
employee/account qualification or account/employee.
Employee ---
EmpID – autonumber – primary key
LName – text
FName – text
MI – text
Phone – text
Etc.

Accounts ---
AccountID - autonumber – primary key
AccountNUM – text
Name
Etc.

Qualifications ---
QualID - autonumber – primary key
EmpID – number – integer – foreign key
AccountID - number – integer – foreign key
Level – text – Trained, Backup, etc.

Karl, Sorry for the late reply. The Backup and Trained tables are employee
names. The Backup table is to be used to select which employess are the

[quoted text clipped - 17 lines]