I have two tables - Parent table listing asset numbers, and another table with records of services for that asset. I would like to lookup the asset number, search the maximum (last date) it was serviced in the records table, and return the comment that is in another column
eg:
Thank you
eg:
Thank you