This sample shows how to create forms to work with many-to-many relations.
Suppose we have a table of stock lists like s16_list_symbols. It is much better to use a form like the following.
You can use space to create or delete the pair.
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.