Hi,
I am new to this forum, but have used a forum a few years back to solve some of my database issues and was very helpful and I am hoping I can sort the current problem.
I have access 2016 running a database designed for the Entertainment business.
Basically, it handles issuing of contracts to various purchasers etc and then produces invoices as required for each event.
The problem I have run into is that I do not know how to get a list of all events in a 30 day period that show all the events and which ones have had invoices issued and which ones have not.
Tables I have in place for this are:
Artist (Events), Contracts, Purchasers, Invoices and Invoice details.
Artist table has a one to many relationship with contracts
Contracts has a one to many relationship with invoices
Purchasers has a one to many relationship with invoices as well
Invoices has a one to many relationship with Invoice details.
I can produce a query showing all invoices issued for a specified period, but I cannot show contracts without invoices issued. Which is a pain as I want to see what needs to be issued.
Any help would be greatly appreciated.
Thank you in advance.