Product Breakdown Structure (1 Viewer)

[mark curtis]

I need to create a field that will allow me to store data in following format (nn.nn.nn.nn )eg 01.01.03.02. This field must also be formatted so that it can be used in a query and be ranked etc.

Thanks again
Mark

 

[chrismcbride]

Maybe I am over-simplifying this, but I would say that a text field is the only way to do this. A number field will not allow more than one Decimal place. I you wanted to force the ##.##.##.## structure onto the field, try something like !<&&.&&.&&.&& in the InputMask of you field. You should still be allowed to sort on a text field (unless it's type is Memo).
Good Luck
Chris