Deletion of Master and Details records in your Online Database

Almost each online database comprises reference columns participating in relations. As you already know One-to- Many relation consists of the Master table and the Details table. One Master record can be related to many Details records, while each Detail can be related to one Master only. There are many questions about automatic deletion of Details…

Online Database

What happens when a Single-Reference column is added

The vast majority of online databases deal with related tables, but only the best ones provide an easy and intuitive way to establish tables’ relationship. The easiest way of creating relations between tables is adding a single-reference column. With this approach, each record stored in the first (‘Master’) table can relate to a record stored…

Relations Pattern

Custom Button to streamline Details Creation

Did you know that by using “Navigate action” you can open a new form of a related detail record in just a single click? You just need to create a custom button that includes “Navigate” functionality. Let’s say, you utilized TeamDesk online database to manage a travel agency workflow. Naturally, you would need to add…

Custom Button

How to Calculate Running Balance

Given lines with amount (positive for income, negative for expenses) in a table called Money, you want to calculate running balance. What should you do? First you have to define order for lines. Standard Date Create column TeamDesk generates for every table can suit your needs – old lines will appear on top, recent on…