last 15 number of related records

[alimrb]

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.

[Søren Dyhr]

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