Sinse FileMaker pretty much automatically controls indexes how do I keep my records in order when I'm using the following numbering system.
1 1.1 1.2 1.2.1 1.2.2 2 2.1 2.1.1 etc.
I have three fields,
One for the prmary digits i.e. 1 2 3 4 ....
The second level of digits i.e. 1.1 1.2 2.1 .....
The third level of digits i.e. 1.2.1 1.2.2 2.1.1 ....
This is a basic techical manual numbering system that needs to be used. Has anyone used another system that might be easier? I'm used to using primary and secondary indexes which FileMaker does not use. I need to be able to find records that match each group in a Find and be able to print reports with the associated text in a table view format that looks like a Word table document.