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.
What I am trying to do is to view a contact record and display a table of projects in which they are a project member.
But I cannot seem to expose the related projects table from the contacts table.
Any ideas on what is going wrong? here is my relationship diagram thus far.
Question
Cannot generate list of projects on contact page
+11no problem,
You are over thinking this.
On the Project members table lookup the field for project name. I bet you have already done that.
The on the contacts record include a Report link embedded report of Project Members and only show the [Project name] field on the report used on the form.
You are over thinking this.
On the Project members table lookup the field for project name. I bet you have already done that.
The on the contacts record include a Report link embedded report of Project Members and only show the [Project name] field on the report used on the form.
+11Okay that makes sense, but how do I filter it only to include projects this contact is associated with? Since it is passing through a joining table.
Did you try it? The report link will naturally filter only for join records which are related to the contact.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.