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!!!

You can view our sample file on duplicate validation here.

http://www.fmdeveloper.com/php/tips_and_tricks.php

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!

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

Hey, Alen, try this technique.

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!

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.

agh thats too bad....I was affraid it might be the case.

Anyhow, the little validation trick was more than enough!

thanx J!