Hello Query Experts
I have a database which is becoming quite a piece of work, but there is something that I'm really struggling with.
I can create queries and I'm becoming quite good at getting the data I want displayed is for example, I want to show all companies that have a Director in related tables, however I have a bigger step I need to take and I'm getting close to having to develop this part of the database.
So I have a company table:
DueDiligence
DDKey - Primary Key
It then has a one to many with
tblKYC
KYCSegmentKey - Primary Key
DDKey as the Foreign Key
This then has a one to many relationship with the following tables all have the foreign key DDKey
tblKYCReview
tblKYCBackground
tblKYCMeeting
tblKYCTransport
tblKYCTerms
tblKYCDeal
As a user updating a form each Company will have many deals or have many meetings.
However the Director wants to only be able to see the very last meeting, and very last deal and very last review in his report.
How do I filter a query to return so many Last records all in one query?