Related table?

[GregBee]

Hi
I am a bit of novice with Filemaker Pro 8 and there is probably a very easy solution to my problem!

I have two tables, "Contacts" and "Projects".

I want to have the ability to list many projects to one Contact in a portal on the contact layout (I know how to create the portal!), I have two layouts, "contacts" & "projects". I have created a relationship between the two tables as follows:

Contact Table: ContactID (Parent) to
Project Table: ProjectIDfk (child).

I created the field "ProjectIDfk" on the project layout hoping to see the "contactID" information in that field thus relating any project created to the client but I see nothing?

Is it something to do with how I initiate the new project record from the Contacts layout?

Thanks

Greg

 

[JeanW]

Create a 3th table (LineItem) where you put the ContactID and each ProjectID together.

Each Contact can have multiple Projects.
For each contact linked to a project, 1 record.

Make your portal in Contact based upon the relationship ContactID(in Contact)::ContactID (in LineItem).
This will show all the Projects for this Contact.

Make a portal in Project based upon the relationship ProjectID(in Project):rojectID(in LineItem).
This will show all the Contacts for this project (if there are)