good day today

[sanam]

I run a landscape business that has a mowing service. I have a list of customers that I pull into a table on the first of every month. The plan is to create invoice numbers for these customers. I will then use those invoice numbers for the month. At the end of the day we check off the customers that we visited, query those customers and add that info to the invoice detail table. At the end of the month the invoices are sent out and the process starts over.

[orange]

Welcome to the forum.
I suggest you write a description of your business in plain English. It will help readers understand your business and where the mowing service (and others possibly) fit with your overall --marketing, service provision, invoicing, payments.....

Here is a tutorial that may help you with the overall process of building a database to support your business. You have to work through it.