locked
Lookup tables for custom fields RRS feed

  • Question

  • Hi, I am using PS 2007 environment.

    I got to create a project level enterprise custom field and associate a lookup table for that field

    If i create a look up table, how do i need to do that if my values in look up table would read as

    1.1.2.0

    1.2.2.0

    1.3.3.0

    Currently i have

    Type=text: code preview=0: sequence=number: length=any: separator=. :

    and providing values as this throws an error "

    • One or more code values in the lookup table contain a code mask separator.

    Thanks

    MP

    Thursday, September 6, 2012 5:20 AM

Answers

  • In a multi level lookup table, you can choose the separator between different levels of the code, by default this is a full stop (.)  - change the coe mask separator to be something else for this lookup table.

    Ben Howard [MVP] blog | web

    • Marked as answer by Mac_cs Thursday, September 6, 2012 6:59 AM
    Thursday, September 6, 2012 6:57 AM

All replies

  • In a multi level lookup table, you can choose the separator between different levels of the code, by default this is a full stop (.)  - change the coe mask separator to be something else for this lookup table.

    Ben Howard [MVP] blog | web

    • Marked as answer by Mac_cs Thursday, September 6, 2012 6:59 AM
    Thursday, September 6, 2012 6:57 AM
  • Thanks a ton Ben.
    Thursday, September 6, 2012 6:59 AM