In keeping with our philosophy of making database building tasks so easy for administrators that editing a database is a no-cost operation, we’ve made *all* table joins into simple one-click links.

In plain English, what does this mean? Well say you’ve got two tables – contacts and sales enquiries. A contact can have a number of sales enquiries. Now if you’re in an enquiries report, you’ve always been able to join to to contacts to pull in contact information for each enquiry, just by clicking a ‘join enquiries to contacts’ link. Now you can do the same in the opposite direction, from parent to child.

So if you want a report of the total value of enquiries per contact, you can start with a contacts report, go to joins and click ‘join contacts to enquiries’. You’re then free to do things like add a calculation of enquiry data e.g. sum({value}).

Of course the manual join option is still there for use if you know a bit about join theory and want to do something out of the ordinary but these new links should make things a lot easier both for database administrators and business analysts. For example, this is what I see when I look at the possible joins from my ‘organisations’ table:

Advertisements