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.
SELECT Students_t.ID, Parents_t.ID
INNER JOIN Parents_t
ON Students_t.Email = Parents_t.Email
Your insights are greatly appreciated.