What if the Data Relationships Tracker doesn’t show any results for the two tables I want to Join?
The tracker helps a lot of the time, but there are also times where it does not. Either the fields it shows you to join are incorrect, or there aren’t any results in the tracker when you type in two tables. If this is the case, then I recommend experimentation. Try some joins and test them in the BAQ Designer to see if the data you need is displayed
Final Notes: It’s important to stress experimentation. BAQs can’t change data in the database (as long as they’re not updatable BAQs) so nothing you do with a BAQ will impact your data. With that, you are free to as you want to get the results you are looking for.