Leb i Sol Posted June 1, 2004 Posted June 1, 2004 Hello People! I am sure this is relatively easy to some of you but I sure could use some help I have two joined fields to indentify a unique record...in my (lineitem-type) file: c_LocItem= ItemID & LocationID How would go about validation (no scripts) so that the next time user enters location ID it would validate: eg. ItemID_______LocationID ABC_________100 ABC_________101 attemmpts to enter the same location ABC_________100 Many thanx!!!
TSC Posted June 1, 2004 Posted June 1, 2004 You can view our sample file on duplicate validation here. http://www.fmdeveloper.com/php/tips_and_tricks.php
Leb i Sol Posted June 1, 2004 Author Posted June 1, 2004 Hi Tim! Thanx for the links! I am aware of this approach of "flagging" or "finding" the duplicates "after the damage has been done"...however, I was looking more for a "validation" that will allow user to "revert field" much like you can when field definitions are sticts...eg. user tries to enter digits into stricly text fields ets.... Any suggestions? Many thanx!
Leb i Sol Posted June 2, 2004 Author Posted June 2, 2004 Perhaps I did not explain myself right...here is the simplified version of the files. All the "validations" are done in NEW_ITEM.fp5 file while the entry is from INVENTORY.fp5 's portal. Should this be scripted? as in -script on selection of the drop list that checks for "flag" field content? ...OR is there a way to use field validation based on some magic calculation that I am not seeing.. MANY THANX! Validate.zip
Leb i Sol Posted June 2, 2004 Author Posted June 2, 2004 ahhh the magic! THANX J.T! ...is there a way (synthax) to get fields from DB involved into message? eg. Sorry, but the Name :DB_field: has already been.... or is this asking too much from non-scripted solution Again, many thanx!
-Queue- Posted June 2, 2004 Posted June 2, 2004 Not to my knowledge, no. You could have it as part of a calculation or set a global with the data. But I don't think it can be part of a Show Message.
Leb i Sol Posted June 2, 2004 Author Posted June 2, 2004 agh thats too bad....I was affraid it might be the case. Anyhow, the little validation trick was more than enough! thanx J!
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now