Relational Data

ZenBase allows for a column in a certain table to be connected to a second table, which means that the first column will hold the value from the second table.

Foreign keys will have to be declared within the application before ZenBase will be able to use them.

To set up a foreign key on a column, you will need to have permissions to modify tables in the database based on Role. An administrator can manage the user roles in the Roles page.

Once declared properly, ZenBase will automatically present a drop-down box displaying the allowed options when editing a single Cell or Record.