This sample shows how to create forms to work with many-to-many relations.
Suppose we have a table of stock lists like list_symbols. It is much better to use a form like the following.
You can use space to create or delete the pair.
This feature has a trick. The s02.xl_app_handlers sets the BitColumn type for list columns. Here is a view result.
This form shows how to edit many-to-many relations with three members.
It places the drop-down lists for the third member in cells. Here is a result of the configuration s02.xl_app_handlers view.
You can find the source codes of the select and change procedures in the code browser below.
You can download samples for any supported database platform with the SaveToDB SDK.