Automatic Joins

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s