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!