New to designing a DB from scratch, please be patient with me....
Currently I have 3 tables; Accounts, Customers, Payments.
My plan is to add forms for data entry after all the tables and queries are finished. Is that a good Practice?
What is the best way to design it to accomplish the following end "Results" needed
1. I need all payment dates per account... To give as a payment schedule
2. I need all remaining payments dates per account... For tracking purposes
3. Get all payment dates with customer address for the next week... For scheduling collectors
4. Get the total of expected payments by date range
Having a hard time designing the queries to get the required results
Thanks for any suggestions