Teri Bridges
Member
- Local time
- Yesterday, 23:05
- Joined
- Feb 21, 2022
- Messages
- 186
I have a question on how to best construct assigning roles to courses.
I currently have a db with tables courses, lessons, topics, events, and roles. What I need to do is assign roles to the courses. There can be many roles assigned to one course.
In the course form, I need to list all the roles that are assigned to take the course.
I was going to use a list selection box on the form, but then i read that this is not a good practice.
I will later need to query the db for which roles are assigned to which courses.
Guidance is greatly appreciated.
I currently have a db with tables courses, lessons, topics, events, and roles. What I need to do is assign roles to the courses. There can be many roles assigned to one course.
In the course form, I need to list all the roles that are assigned to take the course.
I was going to use a list selection box on the form, but then i read that this is not a good practice.
I will later need to query the db for which roles are assigned to which courses.
Guidance is greatly appreciated.