Validate on Compound_Field for duplicates creation

[Leb i Sol]

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]

You can view our sample file on duplicate validation here.

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

[Leb i Sol]

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]

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

[-Queue-]

Hey, Alen, try this technique.

[Leb i Sol]

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

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]

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

Anyhow, the little validation trick was more than enough!

thanx J!