Compiling a list from two tables

[AkakuMatt]

I have two tables in my database, which share information, (or should)

In table 1 i have people and they are all assigned an ID.

In Table 2 i have projects that are defined by an ID as well.

In Table one i have the Person ID in Table two i have the project ID as well as the producer ID. The producer ID co-insides with the Person ID (its the same)

I Need to figure out how to script to pull All of the projects Listed with Producer ID XX

I have a tabular page built so far that has person on 1 and projects on two with several more tabs. so when i select a person in the first tab i want to be able to tab to the projects page and then see their projects listed with the name and verious other fields in the column

Im using FM 10 Advanced Pro

Everything.zip

[bcooney]

I'm having problems with your attachment. It doesn't decompress for me.

From what I can tell, all you need is a portal of projects on the Person form view (a layout based on a Person table occurrence) using a relationship where PersonID=ProducerID.

[AkakuMatt]

I'm having problems with your attachment. It doesn't decompress for me.

From what I can tell, all you need is a portal of projects on the Person form view (a layout based on a Person table occurrence) using a relationship where PersonID=ProducerID.

Here it is again

Everything.zip

[bruceR]

What is the intent of the relationship being based on both Producer and Coproducer, both linked to PersonID?