Showing related list records inside of a form - How To
Alright. I have two lists, one for incident reports and one for subject files.
What I want is for the subject file, when viewing the data as a form, to show a list of incident reports on the form that are related to that subject.
Example.
Bob vila breaks into this old house(See what I did there? ). He's been caught and the security officer is writing up a report. The security officer notes the subject, Bob vila, in the incident report. The security officer also creates a subject file for Bob vila.
When the security officer goes back at a later date to view all data on Bob vila, I want them to be able to look up the name, bob vila, click on his subject file and view it. In that view, it should show the details of what was filled out in the subject file, as well as links to the "this old house breakin" incidident report.
I've been doing a lot of looking around and it looks like related data and database join might be the method I want to use, but I'm unsure and still slightly unclear how to make it work even after watching and reading the tutorial and wiki. I'm sure something similar to this has been done before, so I'm looking for someone to guide me in the right direction of what I want to use to procure this result.
Thanks in advance!
Alright. I have two lists, one for incident reports and one for subject files.
What I want is for the subject file, when viewing the data as a form, to show a list of incident reports on the form that are related to that subject.
Example.
Bob vila breaks into this old house(See what I did there? ). He's been caught and the security officer is writing up a report. The security officer notes the subject, Bob vila, in the incident report. The security officer also creates a subject file for Bob vila.
When the security officer goes back at a later date to view all data on Bob vila, I want them to be able to look up the name, bob vila, click on his subject file and view it. In that view, it should show the details of what was filled out in the subject file, as well as links to the "this old house breakin" incidident report.
I've been doing a lot of looking around and it looks like related data and database join might be the method I want to use, but I'm unsure and still slightly unclear how to make it work even after watching and reading the tutorial and wiki. I'm sure something similar to this has been done before, so I'm looking for someone to guide me in the right direction of what I want to use to procure this result.
Thanks in advance!