I need to show three things in the detail section (or whatever-section
):
1) Customer Number
2) Last Result
3) Date
A table where "Last Result" is stored exists obviously, but has a many to many relation with the Customer_View Table.
So A customernumber can have multiple results.
I only need data associated with the very last result. The result is associated with a date/time field. The most recent date/time field implicates the last result.
I wouldn't know how to do that. Can you help me?
Edited by Valmont - 04 Jun 2007 at 12:53am
IP Logged
