I need some help setting up a query for a web site. I have three tables:
tblUser //contains users
tblRole //contains roles i.e. administrator, faculty
tblUserRole //linking table for many-to-many relationship
tblUserRole contains two fields, user_id and role. These are linked from the other fields. What I want to do is query this table and display the roles for each user in a listbox. Does anyone know how I can do this?