Checkbox function- Access beginner in the Construction Industry

[Adam S.]

Hello all,

Quick explanation of what I am trying to accomplish:

I have created a query that allows users to search for "Spools"

In the construction industry, a spool is a length of pipe, along with several fittings and flanges needed to make that length of pipe. So, a spool may have 10 ft of pipe, 3 flanges, and 2 fittings.

When the user searches for a specific Spool Number, it returns all of the material needed to build that spool, what we have ordered, and what we have on hand. If the user see's that we have enough material on hand to build that spool, I want them to be able to click a checkbox that says "Build this spool?"


I just now figured out how to actually throw that check-box into the form (I wasn't lying about being a beginner)

Now the complicated part. We create Work Orders that are made up of many spools. So, for example, when a user is making a work order, he will assign maybe 100 spools to that work order. This is why I have the checkbox function. I want the user to be able to search for all the spools, decide if they have enough material to be built, and upon deciding that it does, he can click the checkbox. When he clicks the checkbox, I want it to automatically deduct the material needed to build that spool from the total inventory, so that when he searches for the next spool he's seeing inventory that has already accounted for building the previous spool.

Can it be done?

If so, how do I make that checkbox bound to a query that would automatically subtract the quantity needed to build that spool from the inventory?

I doubt I have provided all of the information needed to answer this, so let me know what further information anyone needs.

Thanks,

Adam

 

[Rich]

What if he needs more than one spool, how will you cope with that?

 

[Adam S.]

What if he needs more than one spool, how will you cope with that?

I have anticipated that, and unless there is a way to search for and display multiple spools, he will just have to search for each spool seperately.

I may just give him access to the query, so that he can filter for multiple spools.

 

[DCrake]

Each spool is just part of a number of components that make up 1 unit. As the Spool is the dominent factor you should have a bill of materials table that when populated will identify all the different components needed. You then sum up all the different parts for the quantity of spolls needed and compare these totals with the quantity in stock. This should tell you how many completed units you can make.