alimrb Posted November 5, 2007 Share Posted November 5, 2007 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. Link to comment Share on other sites More sharing options...
Søren Dyhr Posted November 5, 2007 Share Posted November 5, 2007 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6109 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now