Physical Address
304 North Cardinal St.
Dorchester Center, MA 02124
Welcome to the skill header Forums. You can ask questions, get help, or help other members out. Join our Forum for free.
Notifications
Clear all
Jan 20, 2025 11:49 am
Hello,
As mentioned before I am creating a database for our family business based off the tutorial project. I am using the same Invoice form but made a couple of changes and need some help filtering my 'Items Sub' form in the 'Invoice'.
We buy and sell equipment, trucks, tractors etc. so I don't have the 'Orders' table to help filter my Items by 'Customer'. The 'Items Sub' form is filtered based on an 'ItemStatus' of 'Sold' and an 'InvStatus' of 'Not Invoiced' like I need, however, I can't figure out how I need to filter the items based on what 'Customer' I select in the 'Select Customer' combo box. The 'Customer' is associated with the item at the same time the 'ItmStatus' is changed to 'Sold'.
I have a feeling it's going to be rather simple, but I'm obviously a Novice! Please Help!
4 Replies
Jan 28, 2025 1:51 am
@fstetson Will do. To answer your question, I have made some changes since my last post so, I now have 'Purchases' and 'Sales' tables to track 'Vendors' and 'Customers' along with the prices. I have a separate table for 'Item Expenses' since each item can have multiple expenses and the total expenses for each Item is calculated with a query. With my new configuration I think I can filter what I need easier but we will see!
