Computing Question

[elvin0809]

hi good day to all of you

i have a question in my borrowing form of inventory system

i have a table name "INVENTORY" and having a fields ITEMNAME, QUANTITY, and AVAILABLE

and i have a form for borrowing
i have a cascading combo boxes for the ITEMNAME to look for the QUANTITY

then my question is what if someone borrow any item then the AVAILABLE will update on how many items are remaining and the AVAILABLE field will not change its value if i add new transactions

THANK YOU SO MUCH

[alansidman]

See my response at

http://www.access-programmers.co.uk/...d.php?t=216989

Alan

BTW: Read this please

http://www.excelguru.ca/node/7

[elvin0809]

See my response at

http://www.access-programmers.co.uk/...d.php?t=216989

Alan

BTW: Read this please

http://www.excelguru.ca/node/7

i cant solve my problem im very confused on how to answer this...
is it possilbe that if i have a quantity_borrowed field and i have a "Left" field on other table the number that i input in quantity_borrowed will add and add on Left field? and to alarm me that i exceed the total quantity of the the selected item? THANK YOU

[alansidman]

Look at this thread. The OP here was trying to calculate inventory balances. As shown in this link, you will need to revise your tables.
http://www.access-programmers.co.uk/...d.php?t=215889
Alan