ODataDB Sample 16 - Symbol Lists

This sample demonstrates how to create forms for managing many-to-many relationships.

Symbol Lists

Consider a table of stock lists like list_symbols. A form like the one below is much more effective.

You can use space to create or delete pairs.

This feature has a trick: the s02.xl_app_handlers sets the BitColumn type for list columns. HereвЂ™s a view of the result.

This form illustrates how to edit many-to-many relationships involving three members.

It places drop-down lists for the third member in cells. HereвЂ™s a result from the configuration of the s02.xl_app_handlers view.

You can find the source code for the select and change procedures in the code browser below.

Choose an object:

Object definition:

You can download samples for any supported database platform using the SaveToDB SDK.