AnsweredAssumed Answered

Scripting a field's index

Question asked by micinfo on Apr 15, 2013
Latest reply on Apr 16, 2013 by LaRetta

I am looking for a way to compare data (a single word) that's entered by a user in a Custom Dialog box (or global variable), against the index of an existing field in that table so that I can warn the user to choose a different entry if what they entered already exists in another set of records in that table.

 

I was hoping there was something like getFieldIndex[fieldname] so that I could do something like If patterncount ( getFieldIndex [fieldname] ; $CustomDialogData ) > 0, but no such luck.

 

Any ideas about how I might compared whether a data entered into a custom dialog field already exists in the current index values of an existing field? I need to avoid doing a Find and I want to search the ENTIRE index of a field, i.e., including records not in the current found set.

 

Thanks.

 

Phil.

Outcomes