G
Guest
I did this yesterday - I'm not sure what the problem is.
I'm setting up tables to create training sessions. Employees (coming from
different orgs) can attend multiple training sessions.
Tables:
Employees
-EmployeeID (pk)
-FirstName
-LastName
-Organization
Organizations
-OrganizationID (pk)
-OrganizationName
Training Sessions
-TrainingSessionID (pk)
-TrainingSessionLocation
-TrainingSessionDate
UsersInTrainingSessions
-UserTrainingID (pk)
-UserInTraining
-TrainingSession
Training Junction
-TrainingJunctionID (pk)
-TrainingUserJun
-SessionJun
What I would love is:
1. The UserInTraining field to be a list box which reads "[LastName] & ", "
& [FirstName] & " - " & [OrganizationName]. Should this be linked to
OrganizationID or OrganizationName? When I link it to OrganizationID, I just
get that PK number, and when I link it to OrganizationName, it beeps at me
when I try to input data.
2. That list to be listed alphabetically by last name
Please tell me exactly where your reply needs to go - which table, which
field and which properties item. I guess I'm just not getting it.
Thank you in advance.
I'm setting up tables to create training sessions. Employees (coming from
different orgs) can attend multiple training sessions.
Tables:
Employees
-EmployeeID (pk)
-FirstName
-LastName
-Organization
Organizations
-OrganizationID (pk)
-OrganizationName
Training Sessions
-TrainingSessionID (pk)
-TrainingSessionLocation
-TrainingSessionDate
UsersInTrainingSessions
-UserTrainingID (pk)
-UserInTraining
-TrainingSession
Training Junction
-TrainingJunctionID (pk)
-TrainingUserJun
-SessionJun
What I would love is:
1. The UserInTraining field to be a list box which reads "[LastName] & ", "
& [FirstName] & " - " & [OrganizationName]. Should this be linked to
OrganizationID or OrganizationName? When I link it to OrganizationID, I just
get that PK number, and when I link it to OrganizationName, it beeps at me
when I try to input data.
2. That list to be listed alphabetically by last name
Please tell me exactly where your reply needs to go - which table, which
field and which properties item. I guess I'm just not getting it.
Thank you in advance.