Big problem! Newbie need help ASAP Stock control and allocation system

[mini_beest]

Guys I need some help!

I am new to this database stuff and my work want me to produce a database which will not only keep stock on printers, scanners, monitors and base units we have in stock but want an allocation system as well.

Basically, a member of staff from a department will make a request for some items. These could be a monitor, 2 base units and a scanner for their location. I need a system which tells the user that the items or qty they want is in stock or not. I know I need to use an unbound box for this but dont know how.

Then I need a form which a IT techie can allocate a job too themseleves and take the item to them once this has been done they sign off the job.

I have a rough idea on what I want in each table but I am really losing time and i need some help or if anyone can do a quick one for me with forms etc I will be ever so grateful!

The tables look as follows:

Dept - DeptID, Name of Dept
Staff - StaffID, Name, Postion at college
Request - RequestID, Date, StaffID
Stock - StockID, Item (monitor), make (CTX), Model (17" TFT), QTY, Status (dead, working, faulty)
Request deatils - ? - Basically this is where the staff member will make their request for what they want.
Allocation - This part needs to be given to a member of staff and they needs allocating out
Techie - TechieID, Name, Postion
Location - LocationID, Location (where the item is going to)

If anyone can help me please post otherwise please please send me an email to mini_beest@yahoo.co.uk

Thank you and hope you can help

 

[mini_beest]

tables done

Ok guys I have made the tables up, But when I open the allocation form I want it to check the stock qty to see if there is enough available.

For example, if they order 10 monitors and we only have 9 in I want it some how to display a message saying there is only that number in, otherwise to continue with the allocation

Also any ideas on how I would do a password front screen using VB in access?

I have attached me database in a zip file

Mini_beest

 

[jrjr]

Try the search function of this forum. It works well and this subject has been covered at length:

http://www.access-programmers.co.uk/forums/search.php?searchid=573156