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

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.

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.