Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
6 years ago

Cannot generate list of projects on contact page

I have a projects table, a project members table, and a contacts table.  The project members table is a many to many since a contact can be part of many projects and a project can have many contacts. ...
Forms
Relationships
reports and charts
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
Did you try it? The report link will naturally filter only for join records which are related to the contact.
  • IvanWeiss's avatar
    IvanWeiss
    Qrew Captain
    6 years ago
    Ah it worked!  When I added it showed the entire report outside of the contact initially which showed all projects.  That is what I thought it was doing wrong.

    You are right, totally over thought it!  Thanks!
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    Well done. Yes that report link field introduces the extra filter really so that only the relevant records Show on the parent resource record.