Printing Each Row of A Portal on a Diferent Report

[Joseph31]

Hello Everyone...

I really need help with this one...

Here is the situation:

I have 2 tables: "Policies" and "Beneficaries"

On table 1 "Policies" I have a portal linked to "Beneficaries" on this portal you can fill in name address etc... things like this...

I have a contract that only allows for one beneficary at a time on it...SO if I have lets say 2 portal rows each one being a beneficary..Is there a way to print the same contract, but have it replace the beneficary each time it prints until there are no beneficaries left...there could be more than 2..

Help?

Joseph

[RalphL]

Do your printing in the related table. Pull data from the other table via relationship.

[Joseph31]

I understand this...but how does it work...printing each row of a portal on a seperate report...

Please read my orginal description

Joseph

[RalphL]

You are printing a record from the related file. You will have to design a layout that displays fields from Policies and from Beneficiaries.

[Keith LaMarre]

In the beneficiary file, make the "Contract Layout" with one beneficiary per contract.

From your Policies file - you need to make a script that says - Go To Related Records (Show only related Records) that goes to your Beneficiaries. Then print the contract layout for all records on display.

good Luck