Version 2.5, Release

I have a table with dozens of pickers and their values. It has a simple structure with a PickerID, PickerValueID and PickerText.

I pass in a PickerID and get a selection of PickerIDs and values to display in a drop down.

I'd like to create a SubType? Entity? Typed List? for each business picker so that we can have a CustomerRegion picker and a SaleType picker etc instead of a single PickerEntity where I have to pass in PickerID=5 for 'SaleType'.

Gottcha: If I create a SubType for an Entity based on the PickerTable then any query direct to the PickerTable won't return values unless covered in the sub types. So I can't have a project with both the editor of the Picker Table and the sub-types.

Is there a way to both have sub types, but also access the main PickerTable freely in an Entity?

P.S. LOVE the new version, thanks!!!!!

I have a table with dozens of pickers and their values. It has a simple structure with a PickerID, PickerValueID and PickerText.

I pass in a PickerID and get a selection of PickerIDs and values to display in a drop down.

I guess the last line should have read: I pass in a PickerID and get a selection of PickerValueIDs and values to display in a drop down. right?

Anyway it's not clear enough Please specify the table structure (Fields types, PKs and any constrains) Also a sample of data (few rows) would give me a better picture.

If I create a SubType for an Entity based on the PickerTable then any query direct to the PickerTable won't return values unless covered in the sub types. So I can't have a project with both the editor of the Picker Table and the sub-types.

Is there a way to both have sub types, but also access the main PickerTable freely in an Entity?

If you fetch the SuperType, all entities in the table will be returned, since all of them are of that type.

Another option is to re-map another entity on the same table and use it without regardless of the previously mapped hierarchy.

Picker ID    Picker Value   Picker Name
1                  1                      Canada
1                  2                      USA
1                  3                      Bermuda
2                 1                    InvoicedSale
2                 2                    BilledSale
2                  3                      TerminatedSale

In this example we have 2 pickers. A CountryPicker and a SaleType picker from the same table.

I was not aware I could have 2 entites both pointing to the same table as when you have picked a table it appears then only at the bottom of the table list when you choose, "Add New Entity"; I had mistakenly assumed that was the 'no touch' list.

That would provide the functionality I need.

Thanks, Ian