Search results

Thanks! I have all the tables set up. Now I'm just confused as to how to populate fields on a report (invoice). I've attached my fees table. Do I need some sort of query to total all these fees for a certain customer?

Here is the basic end result I'd like to see. If an item hasn't been paid, it needs to stay on the new invoice (like the 2nd item Model Validation fees). If it has been paid, it needs to be removed and the client account credited. Do I need a table for each account and the amounts charged...

Honestly I haven't gotten very far on the project. I think I have my table structure set up properly, but can't figure out where to go from here. Which tables need to be related? I know that the customers table and invoices table needs to be linked. I'm finding it hard to visualize what will...

Hello everyone, New member here, also very new to access and relational databases in general. I'm trying to design a billing and invoicing database and can't seem to figure out how to link the tables and track the payments made by customers. How can I proceed to track the payments and make...