Help me create a POS system with Stock and Inventory management for ingredients (JAVA Ant)

[shut ether]

I'm in dire need of help, I have a defense due tomorrow and I'M REALLY stuck on the POS part of my system. My system consists of products and stock (AKA Ingredients). The idea is that whenever someone purchases a product it auto deducts the ingredients with certain amounts. The hard part is that the products and ingredients are custom created by the user/client. I'm having trouble trying to find a way in which I can create a product and add options where they set the amount that will auto-deduct from the custom-set ingredients. I'm burnt out after 12 hours of coding please help

[wooden cliff]

⌛ This post has been reserved for your question.

Hey @shut ether! Please use /close or the Close Post button above when you're finished. Please remember to follow the help guidelines. This post will be automatically closed after 300 minutes of inactivity.

TIP: Narrow down your issue to simple and precise questions to maximize the chance that others will reply in here.

[gray bronze]

Can you be more specific about what it is you don't know how to do?

Is this using some web technology like Spring? Are there databases involved?

@shut ether

[shut ether]

I'm using netbeans with microsoft access as my database,

I'll try to make it as specific as I can. I have a pos system where the client can create his own products with prices and such (for a cafe). And it also has an inventory system where the client can input inventory items like sugar, boba, flavoring. My job is to link the ingredients(inventory items) to the product where everytime someone purchases a product the ingredients get auto deducted(due to the product consuming the ingredients).

[gray bronze]

I didn't even know java had a way to interface with microsoft access, is there a JPA driver or something?

[shut ether]

I'm thinking of automatically making a new table epr product that's linked with the keys for the ingredients so I can input multiple items to one product

I use jdbc

[gray bronze]

interesting

but I don't know anything about microsoft access in particular

[shut ether]

Its just ur usual database xd same queries and such

[gray bronze]

okay, but then it's just a matter of defining your schema and logic

and it's not too complicated; just give each ingredient a foreign key to the product it can be used, or a join table if an ingredient may be used in many products

and then when a product is ordered, just find all ingredients by their product foreign key(s), and decrement their stock value or whatever

[shut ether]

Yep I might just do that

Thanks for the help man

[wooden cliff]

If you are finished with your post, please close it.
If you are not, please ignore this message.
Note that you will not be able to send further messages here after this post have been closed but you will be able to create new posts.

[shut ether]

😄