experchange > solomon

Dave (09-23-04, 04:55 PM)
Need to validate the second segment of customer number
against contract number (one segment)in contract
maintenance.

Code Type Maintenance has "Field Class" and you can
validate on Customer number, but my customer number has 2
segments.

Is there some tricky way to create another option that
would appear under Field Class that links to a virtual
column in the SQL database where the virtual column is
only the second segment of the customer number?

Any other ideas how to do this? I guess you can do it
with a VB script in customization manager on the field?
Ken (09-27-04, 11:44 AM)
You could do it without field classes. Export segment from
custid into excel and paste into code file maintenance,
then write an insert trigger so that new customer details
are added to the code file.
[..]
Similar Threads