Forum Discussion
EvanMartinez
3 years agoQuickbase Staff
Hi Paul,
Since you already have the records in your Join table that show if a participant has gone to an event or an event was attended by a participant you should just be able to make a report link field on both of those tables to match things up and show a report.
For example in your participant table you would create a report link field and then in the field settings you would go in and set it to match the record ID in the participants table to the related participant field in your Participant-Event table. Then you can set up the report being used for the report link field to show the fields you would like and it should show you all your join records related to that participant. Then you could do the same for Events matching up the record id in the events table and the related events field in your joins table. If you use a custom key field in either of those tables you may need to use those key fields instead of the default record ID.
------------------------------
Evan Martinez
------------------------------
Since you already have the records in your Join table that show if a participant has gone to an event or an event was attended by a participant you should just be able to make a report link field on both of those tables to match things up and show a report.
For example in your participant table you would create a report link field and then in the field settings you would go in and set it to match the record ID in the participants table to the related participant field in your Participant-Event table. Then you can set up the report being used for the report link field to show the fields you would like and it should show you all your join records related to that participant. Then you could do the same for Events matching up the record id in the events table and the related events field in your joins table. If you use a custom key field in either of those tables you may need to use those key fields instead of the default record ID.
------------------------------
Evan Martinez
------------------------------
Related Content
- 6 months ago
- 2 years ago
- 2 years ago