Tempo

To set up a reference column in Tempo, click the ‘Table Settings’ button in the top right corner of the table. In the pop-up screen, click the Pencil on the column you would like to be your Reference Column, navigate to the ‘Special Column’ dropdown and select ‘Reference’. Click ‘Select Reference Table', choose your Reference Table, Display Column and Value Column and select ‘Apply Reference’. Now click the ‘Update Column’ button and ‘Save & Close’. Now your table has a reference column.

To add a primary key to a table in Tempo, click the ‘Table Settings’ button in the top right corner of the table. In the pop-up screen, click the Pencil on the column you would like to be your Primary Key, check the box in the ‘Primary Key’ column and select the ‘Update Column’ button. ‘Save & Close’ and now your table has a primary key.

To connect Tempo to your database, click the ‘Tempo Databases’ button on the left sidebar and navigate to ‘Databases List’. Click the ‘+’ icon. Name your database and then supply an ODBC Connection String which will allow Tempo to connect to your database. Verify the Connection and proceed to select the tables you want to have in your Tempo Database and click ‘Save’. Notice the database has been created in Tempo and your selected tables are in it.