Going around in circles again with Access SQL
I have a database that lets people register themselves and their friends for a working holiday. There is a registration fee to be paid for each person signing up to join.
I have an Orders Table and a Registrations table.
I need to do a report that shows a list of orders by date, but imports the Fullname from the first registration found connected to this order to give a LEAD NAME
Order ID | Date | Lead Name | Total
This should be fairly simple nested sub-query (right?) but I'm getting tied in knots with Access.
Any help appreciated.