decimal points in a number field

[Jalz]

How many decimal points can I store in a number field. Can I store a number in the following format for example without any serious repercussions

1.12.34.123.5749

I wont be using them for calculations, however I will be using them for sorts (as I am trying to create a folder tree, each decimal point being the parent of this record, if that makes sense).

Thanks

Jalz

[bcooney]

I think you'll need to put that in a text field. Have you read Mikail Edoshin's white paper on Hierarchies in FM? Or looked at SeedCode's CC Hierarchy.

But you might want to read this thread also.

[Jalz]

Thank you, i'll have a browse through the links you've given me. Pity the seedcode demo is locked, its only something simple I want to achieve for my web app.