How to show records from two tables into one table?
Is there a way to show all records from specific fields of two tables into one table? I have two tables with fields of the same type (text). I created a matching relationship for a field of each table that suppose to contain the same data. I have only been able to show the matching records from the current table chosen in the "specify calculation" dialog box. I want to show all records, even if the records don't match.