Use one form to enter information into three diff. tables in acces

L

Larry

I'm creating a data base which will keep up with inventory of corrective
lenses. I'm trying to enter the quantity ordered, received & issued of the
same part number, using one form, instead of three seperate forms. Can this
be done? I'm using Access 2000.
 
C

Chris

May I suggest creating a table with part#, numOrdered, numReceived and
numIssued as fields? Or is there anythign else about your database that
prevents you from doing this?

Chris
 
Top