Link between Data Sources

(0) Share

Report

Posted on by mimi51340

Hello,

I have created a new table in which I want to display a drop-down menu with the list of customers (no problem there). And depending on the selected customer account, I want to display the name of the customer in an additional column by retrieving the name directly from the customer table.

I created a new form like this :

In the Data source I added a link from CustTable table.

I added the custable.name in my form.

But my issue is when I try to add a new record in my new table "TRI_NettingCorrelationAR", the customer name becomes blank :

Could you help me please ?

Thanks a lot.

I have the same question (0)

All responses (10)

Answers (1)

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Hi mimi51340,

Could you try changing the join type to "Active" and check if that resolves your issue? You should also set the AllowEdit, AllowCreate and AllowDelete properties to "No" for CustTable.

Was this reply helpful? Yes No
mimi51340 50 on at

Like (0)

Report
Copy link

Link copied!

Hi Gunjan Bhattachayya ,

Same problem with the option "Active".

It is very strange because I tried to create a second record. I closed the windows and reopened it.

And I can see the name of the customer because only if I click on the field :

Else the field is empty:

Thanks.

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Hi mimi,

Yes. I didn't think through that. Active won't work for you. The easiest solution will be to add a display method in the new table that returns customer name and you can then add that to the grid.

Was this reply helpful? Yes No
mimi51340 50 on at

Like (0)

Report
Copy link

Link copied!

in the table or in the form I need to create the display method ?

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

You can create it in the table only. You can use the name of the method in the data method property in the form control.

Was this reply helpful? Yes No
mimi51340 50 on at

Like (0)

Report
Copy link

Link copied!
I created this method in the new table :

display CustName custName() { CustTable custTable; ; return custTable::find(this.TRI_CustAccount).Name; }

I added the method in the form, but the field is empty in the form...

Thanks

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Please share screenshot of the form control properties with this data method.

Was this reply helpful? Yes No
mimi51340 50 on at

Like (0)

Report
Copy link

Link copied!

Yes no problem.

On the field from the form :

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

You need to fill in the Data source property as well with the table name. That should get it working.

Was this reply helpful? Yes No
mimi51340 50 on at

Like (0)

Report
Copy link

Link copied!

Perfect now it works :) .

It is a pity that the link does not work directly on the data source. There must be a wrong parameter somewhere...

Was this reply helpful? Yes No