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

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

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

Please read my orginal description

Joseph

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

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