Loan system problems

G

Guest

Situation brief:
Army Cadet Unit Stores System would like computerised stock control/loan
system.
Database hase 3 tables: CADET (holds personal details of cadets-name, rank
etc), INVENTORY (holds details of stock-itemID,description,total quantity),
LOAN (details which cadet has borrowed which item)

My problem:
i cannot get the INVENTORY table to update the quantity, as items are
loanded and returned.
have no idea where to start. any help would be immensely appreciated. thanks
 
G

Guest

just to clarify.this is a college project so im not really allowed to use
whole templates, but can get away with bits of 'em. thx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Complex Append Query 1
HELP WITH DESIGN BASED ON MOVEMENT OF ITEMS 1
Help again Oracle!..POS Register -2 1
Converting text files to Excel - a difficult one 1
phantom clone partition mounted at J: as system boot drive 5
Problems Loading Large String Array into Array variable 6
AMD R600 Architecture and GPU Analysis (long read) 5
LITEON's dark secret? 50

Top