Multi-Location Inventory Managment System

Hey everyone need some help on a project I am currently working on.


I have a data base program that I have created. Its for an EMS company..


I have the following set up on it as of now.

TABLES
Categories - For the products
tblCertifications - Monitors the EMTs/Paramedics Certifications
tblProducts - Lists out the products we use (ID / ItemName / Category / Type (Each/roll/etc) )
tblSecurityLevel - defines the security of the user logged in for the login script
tblUsers - lists out the users allowed to access the system
Types - Defines the type of location where items are stocked (Vehicle (AMBULANCE) / Station / Bag (EMT/Medics Personal Bag) )
Units - Defines the locations of where items are stocked (All the vehicles, emts/medics with bags and the two stations)

QUERIES
Certification Query - Queries the number of days until an certification expires

FORMS
AddItems - Allows a user to add a product we use to the product table
AddUnit - Allows a user to add a unit, emt/medic with a bag, or station to the Units table
AddUser - Adds a user to the database
Admin - The admin screen
frmUserInfo - allows a user to change their password
Login - the form used to login

RERORTS
Expiration Report - Runs a report for certifications expiring in the next 60 days


With that all laid out...

I need to set it up where I can transfer products from the STATIONS to the units and/or bags.

at the same time of doing the transfer minus the stock from the station and add it to the unit.

I would also, then need to set it up to see when levels are low on a vehicle or bag to restock them



I have tried multiple ways to get this to work. however I have been unsucessful at this. Nothing I have tried works.



Thanks
L. Zook
EMT


My knowledge is mostly in EXCEL VBA but access seems to be a better format for this project..


ANY HELP YOU ALL CAN PROVIDE WILL BE GREATLY HELPFUL.


FYI: CROSS POSTED AT:
utteraccess.com/forum/index.php?showtopic=2031382[/code]
accessforums.net/database-design/multi-location-inventory-managment-system-54997.html

cross posted
http://www.accessforums.net/database-design/multi-location-inventory-managment-system-54997.html
When you cross post, please advise readers that you have done so. Nothing wrong with cross posting, but is considered good etiquette to inform users.

Here's why.
Good luck with your project.

jdraw said:

Nothing wrong with cross posting, ...[/URL]

Click to expand...

Unless you want the experts to respond.

As you can see once the two that did respond figured out it was cross posted most activity stopped.

I have seen this happen many time with cross posting over the past 10+ year I have been active on many of the Access forums.

In my experience cross posting at the same time really does not help.