We won't have that many transaction types yet. Just Add/Remove. So I should probably do away with transaction type. I feel like it was unnecessarily causing complications from the beginning. The only way I can see it helping is if we use a barcode scanner to enter quantities I don't know if...
I think from what I've looked into so far I'm going to keep an InitialQuantity or BaseQuantity field in my MasterInventory to serve as comparative point when I run the query (unless it's absolutely not needed). Ideally in the end I would also like some form of automation or pop up to flag when...
Hello all,
I'm new to Access and am starting up a very simple lab inventory database. The transactions are simple and there are no aspects of sales involved. A lab worker needs to stock material on the floor, he removes what he needs and then logs a transaction in the database.
I have a...
Hello all. I'm currently an 'adult learner' college student retraining for automation engineering. I've currently taken on a database project for my campus job and am looking for good resources and suggestions to get me through. I have some c++ coding experience but now SQL. I have just...