[mso] RE-VALIDATION ON ACCESS DATA BASE

I have designed a data base for excess inventory.
This data base file consists of several tables; one of these tables contains
part number, price and specification, and other pertained information
regarding the part identification.
This file is called "MATERIAL DATA BASE" and part number is the primary
field in this table. 
This table is my permanent data base file and I use this table to retrieve
pertinent information about the part number.

I have another table called "PART UTILIZATION" that shows part number,
quantity and date that parts have been used. There is no primary field in
this table. 

Currently I enter data in to "PART UTILIZATION FORM" and perform query to
retrieve pertinent information about the part number. 
After the query is done I have to check and see if all the part numbers that
I have entered in "PART UTILIZATION FORM" are in the query list.
Problem is if I make a mistake and miss type a part number I will not know
about this data entry error till the query is done.

I was wondering if there is a code or expression that I could put in my
"PART UTILIZATION FORM" to validate part number that I enter in to this form
against the "MATEIAL DATA BASE" table instantly and provide immediate feed
back prior to execution of full query.

Currently I have an intermediate step for validation prior to query
execution, this is very time consuming.
I am looking for a short cut.

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: