Search results

Hi Matt, Thank you for your response! Would you mind sharing a bit about how you're handling BOMs?

What would this update query look like? I'm struggling with the logic behind removing multiple parts at once, so far I have only made update queries that remove one part based on the part number and quantity entered by a user

As of now I just have the quantities in a field of the inventory table. I could make individual tables for each of the four items though. Would this make it easier to remove them all at once?

That BOM lesson is a little different from my situation.. I have a huge list of parts (over 300) and I have four different "assembled products" that use a variety of parts in different quantities (eg. 6 screws, 2 bearings, 1 shaft, etc..) I'm wondering if I can put these required parts in a...

Okay, sounds like your BOL field is similar to how I'm using work orders. What I'm more concerned about is having a bill of materials for a finished product that contains different quantities of multiple parts from the inventory table. I'm wondering if there is a way I can have one table (or...

Thank you both for your responses! I have taken an access course on Udemy, and I've created tables for Inventory, Customers, Employees, Work Orders, Sales Orders, Suppliers Inventory added and Inventory removed (both added and removed record the transactions in a table, while update queries...

Hi there, I'm new to Access and I'm developing a database for a small business that includes an Inventory table, where all parts are listed. I am hoping to create bills of materials for assembled products (finished goods), which would include some parts from the Inventory table (parts included...