Do key fields need to be the same types when setting up a new user defined relationship?

August 31, 2018

No, neuEdit will attempt to find the related records by mapping the fields to a common type.  The following rules will apply when mapping fields of different types:

  • a character field that’s mapped to a numeric field – the numeric field will be converted to character.
  • a decimal field that’s mapped to an integer field – the integer value will be converted to a decimal.

Was this article helpful to you?