Device assembly management

Question

I have a db of parts in an Access db. Now I wish to create a kind of construction management.

Imagine to have in warehouse some pieces, and you have to assembly devices starting from them.

I wish to create a query in which I introduce group name and I get a kind of bill of material with available and requested quantities to assembly.

Example: Warehouse table (already existing)

[code]¦[Quantity]
A¦3
B¦4
C¦0...
Device "Alpha" is made by (I don't know how to declare these devices composition)

[code of which Alpha is made]¦[Quantity for mounting Alpha]
A¦2
B¦0
C¦1
I launch the query (as Input I'm going to pass "Alpha", the name of the device) and I get a table like

Device name: Alpha
[code]¦[warehouse qty]¦[required qty to be picked from warehouse]
A¦3¦2
B¦4¦0
C¦0¦1==> error: I can't assembly because 1 piece is missing

Answer 1

@Andrea Vironda

We are responsible for general issues of Office desktop clients like deployment and activation about Access but your issue is more related to Access query which is beyond our support.
I would suggest you to post your issue on the Access for Developers forum to get more help.

If you have any updates, you could also share the solution on this thread.

Thanks for your understanding.

Regards,
Erin

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.