Trying to use the new feature in Reports to link data from another form. Essentially appears to work the same as a Join in SQL.

However when I go to choose the variable from the joined form to link on, it only shows similar field types, not all fields. I want to link on the value of the field, not the type.

For example ON Form1.ID = Form2.ID

I can't access Form2.ID because the field is a different type.