I'm new to database building. Am having a problem whereby my portal doesn't appear to be working. Not sure why.
Basically, the first entry from a related table shows up, but none of the ones to come after.
For e.g., I have a Survey layout with among others "Date"and "Survey_ID" fields. I then have a Survey_participant layout where I inserted a portal to log the related Date and Survey_ID fields from the Survey layout if a Survey_participant is logged. So basically for each Survey_Participant I want a running list of occurrences in the Survey layout sorted by date and survey_ID. BUT only the first entry (data from the first time I fill out a Survey) will show up and none of the ones entered after (i.e. additional Dates and Survey_IDs). Any tips/advice?
A portal shows a list of (only) related records. How are the Survey and Survey_participant table occurrences related on the relationships graph?