AnsweredAssumed Answered

Display data from unrelated table using executesql

Question asked by kawaii on Mar 14, 2018
Latest reply on Mar 16, 2018 by philipHPG

Hi,

 

I have a layout using table X, and I need a couple fields to display from table Y. The two tables are unrelated. I am using Executesql(Calculation), but when I debug it/run it, I run into "This operation could not be completed because the target is not part of a related table". I thought you were allowed to do this with executesql? I also don't want to build a relationship between these tables. Please help!

 

 

Also, how would i use executesql with a global variable?

e.g " Select FName, LName from table WHERE studentID = $$GetStudentID "

 

 

Regards. Thank you!

Outcomes