View Full Version : What would the code look like?


Leroy Jones
03-08-2005, 10:51 AM
I need a "Hey this field is not Unique" or a "Hey this inventory ticket is on another work order" message when a user decides to reserve a bin full of inventory, even if another user has already reserved the bin for thier work order.
The Unique only validation does not work becuase we need to let these users use the same material if need be.

How could I use a "if key_unique" statement?

Any comments would be apprechiated.

Cheryl Lemire
03-08-2005, 12:08 PM

Do you need help with the message box or the if statement completely? Are you using V5 or V6, you have a similar post on the other message board? You will get more accurate information if you are posting to the board of the version you are using as there are some differences in the two versions.

Good luck

Leroy Jones
03-09-2005, 06:34 PM
I have V6, I need help with the expression statement completely. I figure once I can get the expression, I could make the database so much more user friendly.

Leroy Jones
03-09-2005, 06:38 PM
I mean V5 V5 V5!!!