Need inventory tracking and invoice forms

[jayvan39]

were you able to open it? and thank you so much for your help..

[burrina]

I am looking at it now. There are some problems I am addressing, Get back to you in a bit.

[jayvan39]

must have been bad lol

[burrina]

Okay, here is what I think you are wanting. I made some adjustments to your tables. They did NOT have a correct Primary key! Using a text field as a primary key, WHY?
Just copy the query and form to your database and then edit your tables, tblInventory and tblInventoryTransactions and ADD the Primary Key and Fake Key that I added and everything should work as it is suppose to. You will need to UNDO your primary key and use the one I added. You can keep the field as it is but eliminate it as the primary key.
Let me know if you have any questions or if this works for you.

Dave