Creating a form with two datasources

tpriyan

Hi
I created a grid in form with two datasources but the values from the second datasource are not populated properly. Can u tell me how i have to make these values properly. Also there's a relationship between the two datasources.

Thanks in advance

arijitbasu

You need to select the Joins and the join types in the form datasource between the t datasources. For an eg. please see the Sales Table or PurchTable forms.

tpriyan

HI,
Thx for the reply. I used joins but i cannot select the field based on which a join is made. Can u let me know how to select a relation field in innerjoin.
Thx a lot in advance

suyesh

Hi,
You have to define the relation in Table(AOT->DataDictionary).

Expand your table and in relation node you can create a relation to the related table using Normal relation type.

Then in form datasource you select join datasource.

For reference See the Table "SalesLine" where relation is made with SalesTable with respect to salesId field.

Then check SalesTable form.
And see the property of SalesLine datasource.

Try in same way.

Rgds,
Suyesh

tpriyan

Thanks a lot for ur reply

Vinoth_mct2003

check out the JoinSouce and linktype propertied of the datasource