Problem to insert data with InnerJoin datasource

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

Consider this :

0777.Capture.PNG

My problem is when I create new record of A, I select my item from B by lookup, but data from B dont populate fields in red. Datasource A and Datasource B are linked with InnerJoin.

Any idea ? Thanks

*This post is locked for comments

All responses (2)

Answers (1)

Community Member Microsoft Employee on at

Like (2)

Report

RE: Problem to insert data with InnerJoin datasource

Thank's a lot both of you !

Crispin John Augustine : I've checked, no datasource properties was missing. For your suggestion to explicitly set value for data from B, I've tried this before posting in forum, but the logic on table B prevent me to do this (an error was thrown by custom check that I didnt want to disable)

Rustem Galiamov : Your solution totally worked in my case, thank you again ! My error was to not explicitly insert data in DS A ONLY before refreshing.
Verified answer

Rustem Galiamov 8,072 on at

Like (0)

Report

RE: Problem to insert data with InnerJoin datasource

Hi Stephane M!

To get data from DS B you need to create record in DS A. So, after selecting value from lookup you should insert records into DS A and then, after creating record, you should refresh your records of both DS by calling DS methods.