I'm making a filemaker solution for real-world files. these are very old government files that have subfiles, and i want to be able to sort results based on them.
I've got a solution for the documents themselves, but i need to add several more characteristics and i'm really confused. Here's the problem: i have each record representing an individual document in a file. I want to be able to do a search for a document, find it, and then be able to pull up all of the other documents in that particular file, so i can see what its been grouped with. On top of this, some of the documents are themselves files, with additional documents stuffed into them. So I need to be able to identify a document as being both a document, and also a file that contains documents.
can anybody suggest how to do this?