S
Shane01
I am creating a database for my Fleet Dept. and have made two tables for
parts inventory. One of those tables is for the parts received and the other
table is for the parts that have been used in the Fleet Dept.. Now the
problem I'm having is that I want to create a form that will not allow a data
entry user to enter a quantity in the Parts used field without there being
parts available in the parts received table quantity on hand field.
parts inventory. One of those tables is for the parts received and the other
table is for the parts that have been used in the Fleet Dept.. Now the
problem I'm having is that I want to create a form that will not allow a data
entry user to enter a quantity in the Parts used field without there being
parts available in the parts received table quantity on hand field.