Printing related data

[Greg M]

I have a three-database system in which I have one file containing personnel records, one record per person. I have two related databases for project managers to record projects and project hours (one project per record), and log who worked on which project and how many hours they should be credited for. In the personnel records database, I have a portal that lists the projects each individual worked on. How can I print out a report for each individual that contains the same data as that portal? Often there are more related records than the number of portal rows I have set.

[Greg M]

I have a three-database system in which I have one file containing personnel records, one record per person. I have two related databases for project managers to record projects and project hours (one project per record), and log who worked on which project and how many hours they should be credited for. In the personnel records database, I have a portal that lists the projects each individual worked on. How can I print out a report for each individual that contains the same data as that portal? Often there are more related records than the number of portal rows I have set.

[Greg M]

I have a three-database system in which I have one file containing personnel records, one record per person. I have two related databases for project managers to record projects and project hours (one project per record), and log who worked on which project and how many hours they should be credited for. In the personnel records database, I have a portal that lists the projects each individual worked on. How can I print out a report for each individual that contains the same data as that portal? Often there are more related records than the number of portal rows I have set.

[BobWeaver]

Where you have a one to many relationship, you should print from the file (or table) which is on the "many" side of the relationship. Then, you don't need a portal at all, and you can use FM's summary parts and summary fields in your report.

[BobWeaver]

Where you have a one to many relationship, you should print from the file (or table) which is on the "many" side of the relationship. Then, you don't need a portal at all, and you can use FM's summary parts and summary fields in your report.

[BobWeaver]

Where you have a one to many relationship, you should print from the file (or table) which is on the "many" side of the relationship. Then, you don't need a portal at all, and you can use FM's summary parts and summary fields in your report.

[Greg M]

I'm still not quite understanding... in my Project databases, the "Participants" field, which records who contributed to which project, is a single repeating field. I need a quick way to print individual reports for 150 individuals.

[Greg M]

I'm still not quite understanding... in my Project databases, the "Participants" field, which records who contributed to which project, is a single repeating field. I need a quick way to print individual reports for 150 individuals.

[Greg M]

I'm still not quite understanding... in my Project databases, the "Participants" field, which records who contributed to which project, is a single repeating field. I need a quick way to print individual reports for 150 individuals.

[dkemme]

If the individuals to send the records to are in a repeating field could you set a loop as such:

Loop

set field gNum,1

set field gTxt,GetRepetition ( repeatingField ; gNum )

Do your printing with gTxt as the recipient

set field gNum,gNum + 1

exit loop if gNum > count ( repeatingField)

end loop

I hate doing this and is why I have learned to avoid repeating fields, but it works.

[dkemme]

If the individuals to send the records to are in a repeating field could you set a loop as such:

Loop

set field gNum,1

set field gTxt,GetRepetition ( repeatingField ; gNum )

Do your printing with gTxt as the recipient

set field gNum,gNum + 1

exit loop if gNum > count ( repeatingField)

end loop

I hate doing this and is why I have learned to avoid repeating fields, but it works.

[dkemme]

If the individuals to send the records to are in a repeating field could you set a loop as such:

Loop

set field gNum,1

set field gTxt,GetRepetition ( repeatingField ; gNum )

Do your printing with gTxt as the recipient

set field gNum,gNum + 1

exit loop if gNum > count ( repeatingField)

end loop

I hate doing this and is why I have learned to avoid repeating fields, but it works.