A READER ASKS: Customers And Latest Order Date

From Dwayne Wright - Certified FileMaker 9 Developer
WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright

APPENDIX 3: A Reader Asks

A READER ASKS
Any chance i can pay you for an answer to a filemaker question? :)

(found your blog, drilled through it but didnt find an answer) (same to be true for a lot of the filemaker forums)

I have a simple need:

Customer Table
Order Table

I simply want the date of the most current order. How?

After sorting the ORDER table I tried calculating the max, and latest, without success.

-------
DWAYNE RESPONDS
By all means, you can always pay me for an answer! It is the only way I can keep Peanut Butter on the shelf. (grin) If you want to do a quick donation on one of the blogs, that would be nice. We can always setup a more formal support system with Virtual One On Ones or consulting services. I have a large number of clients that purchase a support bundle and then contact me when they need the occasional help getting over a FileMaker design speed bump.

About the latest order issue, there are a couple ways to do it but one is ruthlessly simple.

- Pull up the relationship dialog box between the relationship from the customers table to the orders table.
- Under the Orders table, choose to have the relationship sorted by order date descending
- Put the order date field on the Customer table layout

Since the relationship is sorted by order date, the field will always show the date by the most current order.
=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2009 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.

ADVERTISEMENT ==================
Help support this blog by considering a donating to its ongoing growth. For more details, please visit http://www.dwaynewright.com/donate.html