November 5, 200718 yr i have 2 tables: eps and price. they are related together by date field. how can i have a portal in eps form that has 15 most recent related record from price table in itself? i do it by deactivating "vertical scrollbar" but when exporting to excel it export all related records.
November 5, 200718 yr Since a denormalization is desired as well as tampering with the clipboard isn't an issue - could you indeed utilize a layout of the same relation sans the scrollbar. But as such won't exports do, but instead could you utilize: http://www.filemaker.com/help/Script-Steps65.html What it does when pasted into a spreadsheet, is that it arrange the data into two columns, data from main record to the left and related stuff to the right - provided just one relation exists. Experiment a little with the utility layout from where you are likley to pull it off. But you have a slight blunder in you relationship, never use real fields such a datefields for the relations, unless you prevented user interactions with the keyfields entirely! --sd
Create an account or sign in to comment