linking data tables

[oconnjms]

Hi
is it possible to link data tables in sololaunch via a common field so users do not have to enter same information twice? Any help would be much appreciated.

[lwyau]

Don't quite know what you are after. Please elaborate more.

[Mikedata]

You have tables with data populated and would like in a particular form have a related field that can pick from the table so you do not have to retype the info.
perhaps a picture of what I say may bring some light and a solution to the problem.

http://www.compudatagroup.com/testobject.html

Hope this the same problem as I would like to have the solution. Mike

[Mike Morrison]

I think what you want to do is create a custom include file that contains your form and set the value= for the various fields to the particular session variable (http://promanual.soholaunch.com/index.php?pr=Home_Page&id=19&read=60&p=1&lang=english) that contains the approriate data for the logged-in user.

[Mikedata]

It seems that by adding scripts we can do almost any thing.
The question here is: when a field is created in a form it can be populated by entering data from the keyboard or by lookup/search a table. The wizard we have here, do not have the option to do that connection. It will be great if the wizard gave us the option.
The sample script described by Cica in prior post does the job as to connect to the table and show the line of the table we want.
But it is only a look up and not part of the fields in the form.
The object here is to have the ability to create a combo field or choice field in the form with the option to connect to a table.
I believe a lot of people could benefit from this addition, either by addon or by script samples in the manual.
The manual covers a lot. But as a user of course we never have enough

Mike

[Mikedata]

I forgot to mention that Cica may be working in creating script that will do it.
Mike