Hi all...please bear with me as I try to explain this one
I have an IT user database which handles user information, trouble ticket tracking and user training tracking where the primary key, UserID, is the same for all three tables.
The userID is not, and cannot, be auto-generated as it is an assigned field based on certain criteria that is then converted into a seven character ID using a hash algorithm.
Three tables specific to the users:
tblUsers: contains specific userID; name, department, access level, supervisor, assigned systems
tblTickets: trouble tickets
tblNewUserTraining: tracks required system training
Individually the tables work fine, no issues, however, my question refers to form creation.
Form 1 intent is to allow for entry of new users. In this case, I would need all the fields from the Users table as well as the fields from the NewUserTraining table. I've attached a generic single line of each table for better visual (primary keys in yelow).
tblUsers to tblNewUserTraining is a one-to-one relationship while tblUsers to tblTickets is a one-to-many.
The form in question deals with Creating a New User and setting up the training tracking. I've attached a generic version of the form.
I need to have the assigned UserID and training info from this form to populate the same fields in the tblNewUserTraining.
I did some research and found a reference to a foreign key, but not sure if the UserID in the tblNewUserTraining can be set as foreign?
A ticket form is independent and will be filled in accordingly, but, I would also like to have the Ticket Command Button on the User form auto-fill the UserID on a Ticket Form (yet to be created). I've tried the DoCmd.OpenForm in add mode without luck...still figuring out the Commmand Button operations
Ideas?
Thanks
TK
![]()