Project Database for Inventory & Monetary Donation Creating a Smooth/Stylish Access

................................................................ I have been trying to fix my access document as I am wanting to track inventory on merchandise gifted by people as well as track their monetary donation. I am starting a non-profit organization and want to be able to tracked gifted items for less fortunate families. I don't have a lot to spend on this so what can be done is truly appreciated. I have 3 tables setup 1. Donor Information (name, address, telephone, etc) 2. Inventory (contains items, size, gender, etc) 3. Monetary Donation (tracks who donated what) I do not want to rely on table entry but rather form entry, so I have created 3 forms. 1. Add Donor 2. Add Inventory 3. Add Monetary Donation My vision for this is: I want to be able to add a donor into the Donor form, that then updates the donor's table. I then would like to (first) add a monetary donation which I can choose the donor's name, enter the amount, and date received and this information updates on the Monetary Donation Table. Also if I wanted to add the donor's donated merchandise under inventory, I would like to add all the information in the inventory form that would then update on the inventory table. What's going wrong: So far, the Monetary form is not associating itself correctly with the Donor Information. It is only grabbing the ID instead of the ID and name. I have not tried the Inventory form yet as I have been trying to work the Monetary form first. I would like to have the following Reports created: - Donations by Year - Donations by Company - Donations by People - Total Value of Inventory - Total Value of Monetary Donation - Items donated away (pull from the checked box under inventory tab) - Inventory by Category - Inventory by Bin Location - Inventory by Gender - Inventory by Generic Size - Bin Value This all works so simply in my head but Access is very tricky when putting it to work. **Side note: I've removed some private information to protect the donors information, so please know a lot of records have been deleted What I Need from you: - Fix this database - Add style to it if not different from mine - Build the reports above - Fix any issues that come about