It's been ages since I needed to perform one of these but I think I need to now.
1) I need to pull a query of accounts, one account can have many contacts, a contact can have many accounts.
2) I need to pull the most recent contact (as determined by the max of their ID number)
3) ***A contact can only appear once in the query ie if Contact 100 is attached to account a, f, d he can only appear as the contact for account a, for account d we need to find the next available contact.
I'm totally at a loss as to how to perform this...hope I provided enough info
Any help or advice is greatly appreciated