filemaker 8 user Posted November 11, 2008 Share Posted November 11, 2008 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! Link to comment Share on other sites More sharing options...
Vaughan Posted November 12, 2008 Share Posted November 12, 2008 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5783 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