Dabble DB

The Dabble Blog

Dabble DB vs Traditional Relational Databases


“Can I create a lookup field in a table to be viewed in another table?”

“I am a seasoned Access user and thought this would be a breeze --but I'm just not getting it.  Your advertisements say that this is a relational database, but I don't see how I build queries, make join relationships, etc…Please help!”

From time-to-time we receive emails from customers that would like to build a relational database in Dabble DB. In a typical database program, a relational database organizes your data into tables that are joined to each other by the specific data in each table.

While Dabble is “relational”, our system differs from that of other traditional databases that some of our customers have become familiar with.

If we look at Access, their relational database is comprised of multiple tables, each relating to a specific topic. Instead of tables, Dabble is made up of different Categories that share similar information.  In our example, Physician is our common field that we will be using to create a relationship and build views.

One Category lists patients in a hospital.

                                                 Category A
 Link1

And, the other Category contains a list of doctors.

                                                 Category B

Link2

Another important difference is that Dabble doesn't make you worry about keys or identifiers like Access. Instead, links are made between entries using a drop-down menu, and you simply select the entry you want to link to.

The List of Entries field and Link to Entry field are the two ways you can link your data and create relationships. List of Entries lets you create one-to-many relations and Link to Entry lets you create one-to-one relationships. For both of these functions the value of the field becomes a reference other entries in your application, just as it would in Access using keys.

To return to the example: we have Physician in Category A and Category B, we can create a relationship between the two categories by using Link to Entry. 

Link3


Click the column, go to Configure, and select “Link to Entry.”

Link4  

Tell the system which category you want to link to. Once you save, Dabble figures out which physicians in category A correspond to which entries in Category B.

After you have created links, you can pull data from the linked Categories and display it on a particular view. First, we’ll create a view that shows us the Physician’s information and what patients are linked to them. To do this, you must add a new column and select the Category that you have linked.

  Link5

We now have a full view of all the physicians’ information and the patients that are linked to them. From here, we can create different views to suit our needs.

Link6

The link is active between both Category A and Category B. So, as you can see in Category A, if we click on the Physician’s name,


Link7
 

We are brought to the information we have entered in for them in Category B. 


Link8

Now, no matter which Category we are in, we can see both information on the Patient and the Physician – all thanks to Link to Entry.

Derived Fields is a very useful tool that will let us pull data from the Categories we have linked. 

So, if I want to compile a list that has all of our Patient information and some of our Physician information, I can go to Category A 

Link1

Click on Physician and select “Add derived field,” and add “Telephone Number.” Then repeat and add “On Call?” and then again for “Hospital”. (If we wanted the Derived Field to replace the original Physician column, we would simply hold down the shift key and it would replace the column for us.)

Link10

Now that we have pulled all the information we would like to see from our Derived Fields, we have a handy view that shows the combined information from differing Categories.

Link11

From there, we can do things like group Physicians, set filters on various fields and create lists and views that are appropriate to our needs.

That’s a very brief and basic overview of how Link to Entry, List of Entries and Derived Fields work, but it gives you an idea of how Dabble DB can be used as a relational database, like many of the other programs you may be used to. 

For a more intricate example, head over to “OUsful.info” and check out how Tony Hirst used Link to Entry. It’s a great example of how other people are using Dabble DB.

Have you been blogging about how you are using Dabble? If you would like to share the love, drop us a line at info@dabbledb.com


See these pages in the help index:
http://dabbledb.com/help/index/link_to_entry
http://dabbledb.com/help/index/list_of_entries
http://dabbledb.com/help/index/derived_fields

0 comments

The comments to this entry are closed.