My database knowledge is pretty limited but im hoping this will work......
The idea is to have a database for customers who have their grass cut fortnightly. The database will be mail merged to form bills every month or so...
So far I've constructed a database with the following tables:
Customer (CustomerID, Name, Address, Post Code,PricePerCut)
GrassCut (CustomerID, DateOfCut, Paid : boolean)
Each GrassCut has the CustomerID and date for the cut along with whether or not the customer has paid for the cut.
The idea is, that i construct an SQL query to represent all the grass cuts where paid is false so to create a table with Customers Name address and dates of all the cuts they have not yet paid for.
Is such a query possible (and if so what is it?) on the tables I have or would i need to restructure the database?