AnsweredAssumed Answered

Importing data into a join table

Question asked by dbeval on May 7, 2012
Latest reply on May 11, 2012 by dbeval

I am evaluating FM Pro and have run into some issues.


I created a table that maps students and guardians, but need to figure out how to populate it automatically.

I already imported the students and guardians, but don't want to have to spend a long time mapping them




Using SQL, I can create a join table that maps students to

parents based on a unique value (email). However, in FM Pro,

I can't find a way to use SQL to do the same.


Something like:


SELECT Students_t.ID, Parents_t.ID

FROM Students_t

INNER JOIN Parents_t

ON Students_t.Email = Parents_t.Email


Your insights are greatly appreciated.