Hello people
So I have a many to many relationship between two tables named "tblUser" and "tblProject". The tables are joined with a joint table named "tblUserProject". The idea is that a user can have many projects, and a project can have many users.
I have also made a form with two listboxes named "lstUser" and "lstProject".
The first listbox "lstUsers", displays the users which are "tblUsers". This part is already functioning. What I want to happen is that when I select a user and presses a button, the projects which are related to the selected user shows up in the second listbox.
How can I do that? Shall I use some kind of query as rowsource for "lstUsers" or what?
Thx.
So I have a many to many relationship between two tables named "tblUser" and "tblProject". The tables are joined with a joint table named "tblUserProject". The idea is that a user can have many projects, and a project can have many users.
I have also made a form with two listboxes named "lstUser" and "lstProject".
The first listbox "lstUsers", displays the users which are "tblUsers". This part is already functioning. What I want to happen is that when I select a user and presses a button, the projects which are related to the selected user shows up in the second listbox.
How can I do that? Shall I use some kind of query as rowsource for "lstUsers" or what?
Thx.
