Relationships
December 1st, 2006 by DaveA question I get asked alot by people that have not seen the demo movie (yet) is whether it’s possible to create relationships between lists. The answer is simple, YES you can!
In fact, this has been a key requirement since the day we started designing Cebase. We wanted Cebase to be a fully fledged database so that you can model your own data driven applications and create something that looks alot like a custom developed application.
There are basically two ways to create relationships, but they both come down to the same thing. I’m having a list of projects for which I also want to track tasks and documents in my example.
Adding a list to a form is probably the easiest method. When you are viewing a record, click on ‘Add List‘ in the toolbar.
Here you can provide the name and fields of the list to add to the form. What happens, is that a new list is created with a LINK field back to the project list.
This brings us to the other method which is to manually add a LINK field to your list. In the image below I’m simply creating a Documents list with a field named ‘Project’ which is a link to a project.
The system will automatically add a documents list to the project form so you’ll end up with something like this.
Ofcourse you can customize these lists any way you like, as I have done. Sign up for a beta account and try it yourself!
May 16th, 2007 at 11:03 am
Awesome! I don’t think it could be any easier than this.
Having the ability to track related information and add lists to forms really makes this a useful tool! I imagine all sorts of applications where lists alone are not enough.