Jump to content

Compiling a list from two tables


AkakuMatt
 Share

This topic is 4415 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 4415 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.