[Gambas-user] Nested data source

[T Lee Davidson]

On 7/4/19 4:04 AM, Marco Ancillotti wrote:
> Il 03/07/19 19:15, Benoît Minisini ha scritto:
>> Le 03/07/2019 à 18:56, Marco Ancillotti a écrit :
>>> uhmmm, so I have a graphical design problem , I have a form that would like to be like:
>>>
>>> 1)---------input from datasource1-------------
>>>
>>> 2)---------insert into datasource2-------------
>>>
>>> 3)---------input from datasource1-------------
>>>
>>> Is there a way to move third part to a datasource3 and link datasource 1 to 3 ?
>>> If I move datasource 2 to bottom the graphical design will be hard to understand.
>>>
>>> thank's.
>>>
>>
>> Sorry, can you be more precise?
>>
> The problem is only graphical, I've made two example of what I have not working and the solution I've imagine if is possible to 
> link two datasource.
> 
> Obviously if anyone finds a better solution it's welcome.
> 

It is difficult to determine exactly what you are trying to accomplish. But, it appears as though you are perhaps trying to join 
data from two distinct tables.

The Table property of a DataSource can take a SQL SELECT statement, ie. "SELECT a.field1, b.field3 from a, b". 
(http://gambaswiki.org/wiki/comp/gb.db.form/datasource/table) You might need to use a SQL JOIN in the SELECT statement to get 
what you need, or maybe a SQL Subquery would do the trick.


___
Lee