Ok, I have a database in access right, it is a database that monitors sales and stock for a computer store. I have a field called In_Stock in a tblItems. The primary key for this table is called Item_ID. There is a table called tblAssets that contains a field called Items and has a relationship to the Item_ID field in tblItems. I want the In_stock field to loop through each record tblassets, look into the field items, check if the field is the same as the field in tblItems - Item_ID and if it is, add one to In_Stock.
Can anyone help me?
(Sorry, that might be pretty hard to understand, but its prob the only way you can explain it lol)
2006-09-23
13:29:15
·
3 answers
·
asked by
Anonymous