July 11, 200718 yr I was not able to find hot to do this so any pointers are appreciated. I have about 800 records. Among the fields I have Item_Name, Picture and Cost. I would like to make a catalog layout where the records would show up horizontally one next to each other rather then vertically. I can get them to show like: Item_Name, Cost Picture Item_Name, Cost Picture Item_Name, Cost Picture Basically a regular list layout. I would like to show them as: Picture Item_Name Picture Item_Name Cost Cost constrained to page width for printing purposes. Thank you.,
July 12, 200718 yr Have you tired setting the print layout to multiple columns? Other than that you'll need to make a cross-tab report. SOme assembly is required. Search Google and the Forums for details.
July 12, 200718 yr There is a way. instead of using list view, set up a self join relationship between your images table. see file attached. Images.zip
July 12, 200718 yr Yeah, good idea to use multiple portals! The OP is listed as using FMP 7, were the fancy portals introduced with that version or did they come later?
July 12, 200718 yr Sorry ! No idea about that , will need to reinstall 7 to check.Currently just have 8.5 installed and of course the trial of 9.00!!
July 12, 200718 yr Author Just made it, it works nice - I have noticed a drawback. It shows only the records that I made the portals for IE: Portal row 1 - 3 Portal row 4 - 3 It does not show the rest. Do I need to make portals for all the records or just make them 1 - 500 501 - 500?
July 13, 200718 yr Yes, you will need to make as many portal rows as you need and as many portals as you need to cover all your records.See attached image files. why do you ask ? Is there some problem in doing the above ?
July 13, 200718 yr After some thought, here's another solution without portals.However I do not know how it will work with large record sets. Go to layout 3 and view in preview mode. Images_2.zip
July 13, 200718 yr I thought printing in columns was the first suggestion made. For browsing, see: http://fmforums.com/forum/showtopic.php?tid/1935/ http://fmforums.com/forum/showtopic.php?tid/184840/
July 13, 200718 yr thanks comment!! These solutions are really great. The original poster should have a wide choice now from the very simple to the complex. Which reminds me to search the forum first in future before delving into filemaker and reinventing the wheel.
Create an account or sign in to comment