I have created 2 tables 1st table (Main) 2nd table (child)
1st table made up of
1 - ID - Unique Auto number
2 - Tender Reference No
3 - Subject
4 - Staff
2nd Table
1 - ID - Unique Auto Number
2 - MainID - connects to (Main) autoID, can be duplicated
3 - Date - entry date
4 - Remarks
When I create a report i will get the following:
Main (ID) / Main (Tender Reference No) / Main (Subject) / Main (Staff) / Child (Date) / Child (Remarks)
This portion i can create in query, however, the next step is what i am try to get.
I need to get only the LAST ENTRY DATE AND REMARKS for each Main (ID)
Can you please help and explain this to me.
Thank you for your help.
Trident