Auto populating a form in access
Posted on 2014-11-04
Ok I am writing a database that helps track training records by position. I have a dbo_positions table, a dbo_trainingcourse table, and a dbo_jobgroup table. The position table has all of the main positions, the training course tracks the different courses inside a position and the job group marries them together. I have created a form, that you select an employee and then their primary position, what I want then is to auto populate , the employee table with their primary positions courses that they need to be trained on, BUT then I need to be able to put a date next to the course when they have finished. I am able to produce the information with a query but I can't tie a date to each course. Any help would be appreciated.