Grid Tab with multiple data source

(0) Share

Report

Posted on by startax

1,845

Hi,

I am working on a form with multiple datasource. In form design i have single grid with multiple tab that is the main issue.

3005.Capture.PNG

In screenshot Overview and Plate Registration tab using same table and other 3 tab using other 3 table. Now i need when i create record in overview tab then user get a new line to create record in all tab with the respect of first record entered in overview tab. User can edit , delete any record that reflect on form immediately. I am trying to do it without any coding this is possible to do it without any code.

Table : A,B,C,D

i am created relation B.A == A.PrimaryKey (A is the main table that used in first two tab).

C.A == A.PrimaryKey

D.A == A.PrimaryKey

Any Suggestion is very helpful.

Thank You.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

XB 1,875 on at

Like (0)

Report

Are dataSource linked on form?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

If the records have a 1 to 1 mapping, then I guess you can use innerjoin between the tables.

Else you may need to try with an active join.

Was this reply helpful? Yes No
Suggested answer

Denis Macchinetti 16,444 on at

Like (0)

Report

Hi Dinkar

Is enough to :

1- Set the Joinsource property of the Datasource B, C and D to the Datasource A.

2- Set the linktype property to Delayed to the Datasource B, C and D

3- Set the InsertAtEnd and InsertIfEmpty properties for all Datasource to Yes

Was this reply helpful? Yes No
startax 1,845 on at

Like (0)

Report

Hi Denis,

I am tried as your suggestion but its not working. I can insert first record when tried to insert second record then tab 3,4,5 record is blank but user created one record in all tab.

Any other suggestion or anything that i am missing.

Was this reply helpful? Yes No
startax 1,845 on at

Like (0)

Report

Hi bala,

When i am tried with inner join then no record come in form. One more thing i am not specify any property in relation.

EnitityRelationRole=

RelatedTableCardinality =

Cardinality =

RelationshipType =

And Active is also not working

Any other suggestion

Thank You

Was this reply helpful? Yes No
Denis Macchinetti 16,444 on at

Like (0)

Report

Hi Dinkar

Inside the Create method of the first Datasource, call the same method of all the other DS, so:

B_ds.create();

C_ds.create();

D_ds.create();

Was this reply helpful? Yes No