Thank you for your reply and patience. I have reviewed your post but it fails to show the relationships and how they connect. My database is not even close to that deep, but If I can see how the relationships join to each table, I can take it from there. Thank you...
I have uploaded my database...
I have now created the 3 tables as suggested. But which fields should be the primary key ??? And also how are the relationships joined ? I tried several differant ways but it makes it much worse than before ???
I am building a small database for a customer. They have a funeral home and needs to keep track of customers and their payments and Balances. I created the tables and primary keys and thought my relationships were correct. My form works well but when I create a query or report I get: source...