Hi there. I have this RA database I created for our small company. I have a few fields. One of them being CarReaderSerial# and RAClosed. The CarReaderSerial# is just 8 digits long of numbers. this is not the key field and you can add multiple RA records for a single serial number since items can be returned more than once. The RAStatus field is just a yes/no field. This field is default to "no" since the RA is not closed. Once everythign has been processed the user goes in and checks it as "yes". my problem here is sometimes customer service forgets that they have already opened an RA for a particular CarReaderSerial#. Thus resulting in multiple RA records referring to the same Serial# that is still open.
Ok here is what I want to do
-if the CarReaderSerial# is already in the database and the RAClosed field is set to "no" -> Do not allow a record to be added. Have a pop up error msg saying "CarReaderSerial# is already associated to an RA record which is still open"
-if there is a CarReaderSerial# already in the database but the RAClosed field is set to "yes" -> Then allow the record to be added
Let me know if this is possible thru events. Thanks ahead of time.
Totally appreciate all your help that I have gotten from this board.
