inventory management db

[farmi]

https://drive.google.com/open?id=1rX...2ck9PCSviLdigD

here;s my db.

i want to track changes in a small inventory db and see what the difference is in whats taken out and whats used.

opiatetbl is the main inventory table
i made a form called opiatefrm where i want users to enter the changes in the inventory.
i also made a button that saves the changes and enters the data in another table calles ''mutaties''
i made a qry to save these changes but it doesnt seem to work when i press save, it gives an error.

did i do something wrong in the qry or in the form?/
edit: i set warnings to off now, but maybe i should have a one to many relationship or something? what am i doing wrong?


edit2: i think its linked the primary key of the mutations(mutaties) table to the one from the opiatetbl. i dont want this. i need to have many records of the mutations in the inventory in my mutaties table. how to do this?

thanks in advance.

[orange]

Many readers will not go to offsite links. Better to post attachments in the forum.

Here is a free youtube video related to Stock Management from Software Matters that may give some insight.
There are several free data models involving Inventory at Barry Williams' site


Good luck with your project.

[farmi]

okay no problem ill upload it here.

Ive actually already built quite a substantial part of the database as you can see.

[orange]

When you post a split database it is advisable to include both Front end and Back end.
Also, when you post a database that requires a password, you might consider supplying a general password.

[farmi]

you can just click right click and close on the login form. the split db is only for the user info. the tables for the database itself are not split and included here.

i could upload another version without the login screens and split db if neccessary?