display latest added notes
hi,
i have a users table clients table and notes table.
users link to clients table via fk and fk from clients to notes.
i want to be able to display the latest say 5 notes added to any client for that user.
could anyone help provide a sql query that would do this for my recordset?
many thanks