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 ? )