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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kimb - 20 May 2008 21:44 GMT

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!

Signature

Thanks,
Kim B.

Reply to this Message

KARL DEWEY - 20 May 2008 23:30 GMT

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?

Signature

KARL DEWEY
Build a little - Test a little

> 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!

Reply to this Message

kimb - 27 May 2008 14:02 GMT

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?
[quoted text clipped - 5 lines]
>> converted to an Access database.
>> Any ideas or help would be greatly appreciated!

Signature

Thanks,
Kim B.

Reply to this Message

KARL DEWEY - 27 May 2008 17:48 GMT

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.

Signature

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
[quoted text clipped - 17 lines]
> >> converted to an Access database.
> >> Any ideas or help would be greatly appreciated!

Reply to this Message

kimb - 27 May 2008 18:03 GMT

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.
[quoted text clipped - 23 lines]
>> >> converted to an Access database.
>> >> Any ideas or help would be greatly appreciated!

Signature

Thanks,
Kim B.

Reply to this Message