set newest record first

[filemaker 8 user]

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!

[Vaughan]

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.