I have a table which keeps a record of incidents and follow-ups to those incidents. Each incident has a unique ID for who the incident belongs to, a timestamp, a Yes/No column to indicate if it is a new incident, and description of the incident. One of the questions I ask the user is if the new entry they are making is related to a prior incident. If the answer is yes, I would like a list to be presented to the user from which they can select the originating incident for that particular individual.
What is the correct way to create this list? I need the list to based on the current record’s ID for the individual and show the related times and descriptions of all originating incidents.