Hello everyone,
I have a database that houses data on employees.
I have a junction table which houses 7 foreign keys.
-Employee_ID
-Division_ID
-Department_ID
EmployeeLicense_ID
Training_ID
Location_ID
Infractions_ID
Each of these tables houses data that ties back to the employee. Each ID is its own primary key in the specific table. (AutoNumber). How can I make a form / what is the best way for me to add new records to my database?