Calculating total from different tables & Limit to list problems

R

Raymond Dean

How do I create a formula, so that 'Quantity'
from "Requisition Details" is subtracted from 'Starting
Quantity' from "Equipment", and the resulting value is
entered in 'UnitsInStock' under "Equipment"?

Also, consider this statement:

SELECT DISTINCTROW [EquipmentID], [EquipmentName] FROM
Equipment ORDER BY [EquipmentName];

Though the statement helps by automatically filling in the
EquipmentID field in the Requisition Details table, it
doesn't allow me to enter a different name than what's in
the list. How can I change it so it'll allow me to enter
new equipment names?

Requisitions
RequisitionID
RequestorID
DateFilled
LocationID

Requisition Details
RequisitionID
EquipmentID
Quantity
Unit
Comment

Equipment
EquipmentID
EquipmentName
CategoryID
QuantityPerUnit
Starting Quantity
Starting Quantity Date
Starting Quantity unit
UnitsInStock
ReoroderLevel
equip_Location
Discontinued
 
Top