A PCR Educator DAT Query can now connect two tables on fields you choose, even when PCR Educator has not defined a connection between them.

What's new

Other table in the connect list. Click the [+] icon next to a table in DAT Query - Step 1 and choose Other table... at the bottom of the list. A second list offers every table your roles allow you to report on.

Join on the fields that match. Pick a field from the table you are connecting from and a field from the new table, then click Add. Add more pairs when records only match on a combination of fields.