Jump to content

last 15 number of related records


alimrb

This topic is 6066 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

This topic is 6066 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.