Setting Subform Links in ChemFinder 7.0.3
Jim Dill 14-15 Mar 02
The 7.0 Version
In ChemFinder 7, when you want to set up a link between a form and a subform, you do it in the Subform Properties dialog:
First you select a field of the main table by clicking in the tree control, and its name is displayed in the "Parent field" box. Then you select the related subtable field from the dropdown. Simple.
Nobody likes this scheme. It's not clear what to do, nomenclature is inconsistent and unfamiliar, it's easily possible to goof up, and there's that pointless icon. We can make it better with a day's work, so that's what we're doing today.
The 7.0.3 Version
In 7.0.3, here's what replaces that dialog:
In this one:
You can choose the parent field either from the tree control or from a new dropdown. In either case, when you change one control, the other changes too.
Box labels are more consistent, and now also include table names.
As an added bonus: you are not allowed to select anything in the tree control except a field from the main table. Clicking on anything else has no effect, nor should it (you can still expand and collapse nodes, you just can't select any other field or table).
3/23/02: This scheme is ready for testing.
Followup (15 Mar 02)
There were some bugs in the initial implementation of the new scheme. Fixes were committed.
Stew responded to the above with this helpful message:
Suppose a right-click on either the interior of a subform or its header brings up the same dialog. Its Form tab must to the subform, Database and Table tabs (and tree control) to the subform's data source. The Field tab would have to work as it does on a main form: if a box was clicked to bring up the dialog, then its field is described in this tab; if no box was clicked --- or if the dialog was brought up by a click on the subform header --- then there is no selected field, and the Field tab is useless. The Subform tab would be used for entering linking info, via dropdowns --- in this case, it might not work to use the tree control to select a link field.
I have more thoughts on this, but decided to postpone any further change until after 7.0.2.
[ ChemFinder | R&D ]