Hi,
If i was creating a many to many relationship between an Employee table and a Training Course table can i ensure that each course is accounted for when a new employee is added and if a new course is added it will show as an incomplete course for that employee (therefore automatically populating the employee userform with a new field)
My goal was an employee form that would have a sub form which would include the entire current list of courses (lets say 15 in this case) and a date field for when it is carried out - but i assume the creation of that list would need carried out via sql once a new employee is added (ie employee 8 added > autocreate 15 records in junction table, one for each course). The reverse would be once a new course is added > auto add 8 records to junction, 1 for each employee
I havent dealt with any many to many relationships before so theres a good chance im overlooking a much more simple solution!
Any help appreciated