Hi,
First post so please be kind.
I have two tables, related by an ID field.
The 'Child' table has multiple records, each with the ID, a date and a time.
What I need to do (and am struggling with) is to display the date and time of the LAST child table record (based on the date and time) related to each browse row.
The child table has a key that contains the parent ID, a date, and time.
Can anyone please advise an elegant way to do this?
Thanks
Paul