Dynamic form - is there such a thing?

Classic Servoy
1

Is it possible to dynamically set the ‘table source’ and the ‘primary key’ for a form ?

The situation I have is how to I address building forms for my reference tables (55 reference tables at the moment).
The reference tables are identical in structure except for the name of the primary key column.

What I would like to do is build a form with a drop-down list of the available reference data that can be edited.
When the user picks one I would like to change the source table and primary key column on the form dynamically then load the data for that table into the form.

Is this even remotely possible or do I need to build a separate form for each of my reference tables ?

Thoughts?
Thanks in advance
Mark

2

Hi Mark,
I think the Table-bean or Foundset-bean would do the trick of loading data from different tables into 1 tableview for you.
You can directly edit loaded data with the Foundset-bean, so that would save you a huge amount of forms.
See Servoy-Plugins.de - Table bean for more info about the Table- and Foundset-beans.

3

Its on the planning for this year