So I need a way to keep track of the number of parts I have and determine if I need to order more parts to build a product.

I work with a company that makes circuit boards. We make a few different boards that use a similar set of parts. The parts must be bought in bulk. This means that all the parts don't need to be re-ordered at the same time.

for example, we have board A and board B.

Board A uses parts 1,2,3,4 and 5.

Board B uses parts 3,4,5,6 and 7.

each board needs different amount of different parts.

how would you suggest using FM to keep track of inventory.

I would like to be able to tell FM I want to make a given board and get back a list of the parts I need to order before the board can be made. Then once the board is made I would like FM to automatically updated the inventory of the parts.

currently I have three tables. One that contains a list of all parts and quantity. The other two contain list of the parts and amount of parts require to build the board.

Welcome to the Forums!

Inventory systems are a challenge. Perhaps this thread will help and the links posted in it.