Create control for generating a FieldPath

[stuarta0]

Take existing logic from dbqf.WinForms.Advanced.AdvancedPartView and create a control that stacks combos (and adds/removes them) as the user chooses fields that have relationships to other fields.

Allow the control to take a FieldPathFactory so at any depth of the path the next set of fields can be retrieved.

This control can be used for the user-defined output field selection and for the advanced search control. Later this control can be developed in WPF and whatever else.

[stuarta0]

Conceivably this could also be represented as a TreeView with literal drill-down through related fields.

Benefits are that everything is visible which makes comprehension faster. Downsides is that it requires screen real estate up front whereas the stacked combo idea only requires as much space as their are fields chosen. Also, recursive fields like the example below would make the tree problematic unless it was loaded on demand (which is OK).

• Invoice
  • Number
  • Date
  • Authoriser (Person)
    • Name
    • Phone
    • Superior (Person)
      • Name
      • Phone
      • Superior (Person)
        • etc...
  • Total Value
  • Client (Business)
    • Name
    • Address (Location)
      • City
      • Postcode

[stuarta0]

Current implementation clears and recreates all combos on every change (and then some). It should at least loop over the combos and check references to data source and only recreate the combos if the references change. This might help the issue where the combo SelectedItem doesn't stick too.

[stuarta0]

Fixed in d37a15b