Skip to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

set newest record first

filemaker 8 user
in Calculation Engine (Define Fields)

Featured Replies

I have two databases

1. customer_database.fp7 that has multiple records per customer. ie:

Name,email,date ordered,product name

record1: joe blogs, [email protected],11/4/2008,product1

record2: joe blogs, [email protected],8/2/2007,product4

2.email_database.fp7 is a database for customer service to answer emails. The two databases are joined by email address.

The problem I am having is that when I come across an email from [email protected] in the email_database.fp7 it shows his old order from 8/2/07 instead of the one from 11/04/08. Is there a way to sort by newest record or something in the customer_database.fp7 so that the related record from customer_database.fp7 will be the newest.

Im newbie to FMP and Im using FMP8. Any help would be great!

Best bet is to "normalise" the customer table so there is only one record per person.

Try sorting the relationship by the date field descending.

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

Account

Navigation

Search

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.