7 Replies Latest reply on Oct 29, 2013 2:35 PM by taylorsharpe

    Product ID - number or text


      I have a standard Invoicing solution, where products are defined as auto-enter serials with unique numbers. This field is on several locations in the Relationsship graph connected to an orderlines table - that also has a numerical number field for the match. Pretty standard I guess.


      One customer would now like to be able to have numbers like 245-1/00X ( manufactury number )


      Any good suggestions for how to solve this problem would be very appreciated.


      Should I say NO - not possible?


      Allow entering these "text" strings into a number field ?


      Change field format to text in both Products and orderlines ?

      ( will this break anything ? )