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

manually.

 

S-t-G.jpg

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.

Outcomes