Sunday, December 21, 2003
Build 291 - Relationship Finder
This build is ONLY available by downloading the Beta Refresh.
A new Developer tool called the Relationship Finder has been added to the Relationship Editor.
This tool is similar to the one found in the Setup Wizard but is far more dynamic and hopefully, useful. You can drag and drop files on top of each other to create relationships or let the AutoJoin (working on a better name) find them for you. When using AutoJoin, you can specify what fields should be ignored or what type of key you use to identify the ID fields. We are still building support for other naming conventions.
Perhaps the cool part here is that if it can find a single key that links two tables, it uses it but if it can't, it will prompt you and you can choose the correct relationship. This should make setting up relationships between even "unknown" tables faster and easier than ever before!
To see it, select Relationship Editor in the System Admin menu and then click Find.
Now, if you are using the Cars file, this may not immediately appear useful so try selecting Upgrade from Previous Version under the Tools menu and specify your original Foxfire! 6.0 directory. Select the Preference set you want to move over and then your other joins should be available .
One thing to be aware of: When it shows you all of the potential joins, they are ALL assumed to be valid. Be sure to hit the Clear All unless you want to add them all in.
Comment
