Jump to content

Validate on Compound_Field for duplicates creation


This topic is 7240 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello People!

I am sure this is relatively easy to some of you but I sure could use some help smile.gif

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

confused.gif

Many thanx!!!

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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.. frown.gif

MANY THANX!

Validate.zip

Link to comment
Share on other sites

ahhh the magic!

yay.giflaugh.gif

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 smile.gif

Again, many thanx!

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 7240 days old. Please don't post here. Open a new topic instead.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.