I should clarify that I am assuming that any nightmare DBs you submit are ones that you were asked to work on. They were someone else's solution - a nightmare that YOU did not create.
All the solutions I work on were started by the business owner, in FileMaker 3 or 5, so they are all quite a challenge
Please be sure to point out that FileMaker's Relationship Graph has NO tools, to help sort out the resulting mess
> I should clarify that I am assuming that any nightmare DBs you submit are ones that you were asked to work on. They were someone else's solution - a nightmare that YOU did not create.
I agree on the lack of tools but also an important lack of meaningful and usable conceptual frameworks.
It seems to me we don't have the language to evaluate, characterize, or solve these problems.
We have seen some wonderful results of conversion and simplified graphs.
We know things about the dependency tree.
How do we build a path to get from "here" to "there" ?
Mine are actually simpler
A single box in the middle, surrounded by 150 or more Relationships
I've been supporting a system that has multiple files (hang over from v6) and some idiot decided to do data separation on the majority of the files...
Actually... there is one worse example...
MANY MANY years ago, I think it was version 4? There was a "hosted" solution on Mac network, which was still on Mac OS 8/9 systems, there where two main issues here:
1. They duplicated files and tried to host them as "one" solution
2. They "hosted" solution by accessing the files across file sharing (not via FileMaker)
3. Files shared where on more than one computer
4. The "host" computers where being used for other purposes (users where on them continually)
5. Reminder, they where on Mac OS 9, which was not multi-tasking, which meant that anyone using the "host", would simply do something like click a menu and eveyone accessing the file would come to a grinding halt.
6. The network was not Ethernet, AppleTalk via phonenet (yes, I am that old)
SUMMARY: Most of the computers where slow, the network was slow, the network traffic was chaos, the files where not being shared properly and not consolodated and NOT centralised and the OS did not allow multiple users working on the one file at the one time... wow. I was amazed they got any work done. ahhh, the good old days.