pim with related tables?

< Next Topic | Back to topic list | Previous Topic >

Posted by jimspoon
May 8, 2011 at 08:19 PM

Many PIMs have items consisting of multiple fields and values in those fields. This allow items to be viewed in a table, where items can be filtered, grouped, and sorted by the values in various fields. In this way it’s like a flat-file database or a spreadsheet.

Are there any PIMs out that allow you to connect multiple tables in a single database? I was looking at the forum for Infoqube and I saw comments that it is not a true relational database program but can be made to mimic one in some ways. The ability to connect multiple tables is very powerful, but it seems a bit conceptually difficult for users, so I’m wondering if anybody has made a program that makes this kind of power more accessible to users in the PIM context.

jim

Posted by Alexander Deliyannis
May 8, 2011 at 08:35 PM

jimspoon wrote:
>In this way it’s like a flat-file database or a spreadsheet.

In reality, many of the PIMs we discuss here are relational databases. How much you can alter the structure and linkages among the discrete tables is another matter though.

For example, when you link a Contacts to an Event in Outlook, you are making associations among separate tables. The kind of links you can make are more or less preset, e.g. you probably can’t link an event directly to a phone number (safe for including it as a comment), only via the Contact who owns it.

If I understand well what you want, your best bet is to modify a ready-made template based on a versatile database, such as http://www.brilliantdatabase.com/examples_databases.html

Back to topic list