Relationships between tables can be defined within the Class page, against each table, in the Freedombase Designer. Once these relationships are defined, popup windows, drilling to related data, select/drop down lists, and displaying related records on one page, can all be applied very easily through Freedombase.

We recommend defining relationships within Freedombase whenever practical; relationships are defined, or ‘attached’ to, the ‘child’ attribute or field, pointing up at the ‘parent’ attribute or field on the ‘parent’ table.

For example, to define a relationship from the CUSTOMER table STATE field, to the STATE table key field, you would bring up the CUSTOMER table in the Designer Customer page, and in the Relationship section, enter STATE as the ‘from’ Attribute, STATE as the Points At Class, and KEY as the Points At Attribute. This tells Freedombase that the CUSTOMER STATE field ‘points at’ the STATE KEY field. (You would also need to enter or select a couple of other items, but those details have been left out here, in an attempt to make the principle of applying relationships more obvious.)