Two of the tables I have in my database are a Budgets table and a Budget Line Details table. They are related by three fields, Fiscal Year, Location, and Funding Source. I have a layout setup with Budgets fields above a portal to the Budget Line Details table. Everything works and looks fine on the data entry layout. What I need to is setup a print layout that will let a certain field on the line detail portal called Projects expand or shrink with what is entered. I tried setting up a layout with no portal and repeating fields for the detail portion but I only get one line of detail for each record. What am I doing wrong? I understand you can't make portals shrink fields so I can't use that method to print. I also want the result to break across pages if the lines won't fit on one.

Use a list layout, make the body part really big then use Sliding/Printing to get FMP to shrink it down when previewed/printed.

Vaughan,

Can you expand on the list suggestion? I need several fields such as fiscal year, location, funding source etc. to be in the header or only listed once on the page and the other fields (gl code, gl descr, amount, and projects to be listed on each line of data that was entered. Thank you for responding.

Vaughan,

Thanks you for your suggestion and it worked great. I wrote my first response before trying your suggestion. At first, I didn't think it would work but it did. Thanks again.