I will start off by apologizing for the lengthy post in advance.
I have 2 tables. One table, tbl_ClientRequest, which stores requirement requests from a client. The other table, tbl_Solutions, stores solutions available.
One solution can possibly solve more than one request, and one request can have many solutions.
What I want to have is a form that lists all the requests (one at a time) and then lists in a subform the solutions associated with the request. I also want the user to be able to select additional solutions in the subform.
I have used a join table to store the Request ID's and the Solution IDs.
So it looks something like this
tbl_ClientRequests
==================
ID Request
------------------
cr1 request
cr2 request
tbl_Solutions
==================
ID Solution
------------------
s1 solution
s2 solution
s3 solution
tbl_Join
==================================
ID RequestID SolutionID
----------------------------------
1 cr1 s1
2 cr1 s2
3 cr2 s1
4 cr2 s3
I have the subform set up now, and it will allow the user to view and add solutions. But I also want to display the solution description as well. Right now, it just shows #Name?
Any suggestions?
Thanks!
I have 2 tables. One table, tbl_ClientRequest, which stores requirement requests from a client. The other table, tbl_Solutions, stores solutions available.
One solution can possibly solve more than one request, and one request can have many solutions.
What I want to have is a form that lists all the requests (one at a time) and then lists in a subform the solutions associated with the request. I also want the user to be able to select additional solutions in the subform.
I have used a join table to store the Request ID's and the Solution IDs.
So it looks something like this
tbl_ClientRequests
==================
ID Request
------------------
cr1 request
cr2 request
tbl_Solutions
==================
ID Solution
------------------
s1 solution
s2 solution
s3 solution
tbl_Join
==================================
ID RequestID SolutionID
----------------------------------
1 cr1 s1
2 cr1 s2
3 cr2 s1
4 cr2 s3
I have the subform set up now, and it will allow the user to view and add solutions. But I also want to display the solution description as well. Right now, it just shows #Name?
Any suggestions?
Thanks!