Copy Master records with Details and Sub-Details

It’s a trivial situation when you need to copy a master record, including details and sub-details. For example, your database stores records of specific products, each product consists of many parts and every part includes many components. In this case you are dealing with 3 level cascade relation. This blog post describes the settings allowing…

Copy Master with Details

Three approaches for Tracking Changes

The changes tracking log is a frequently asked question. That’s why we decided to describe three approaches that allow the organization of a changes tracking log. The common idea is that changes are registered as related details that are kept in a separate table. In this blog post we’ll describe three different approaches to implement…

Changes Tracking

Generate Copies of Master and Copy Master Details

If your online database includes related tables, you may need to copy a Master record and copy master Details listed in the related details views . To simplify this process, the custom buttons with the Navigate actions can be adjusted. Let’s consider the Project Management database, where each project record is related to many Stages…

Copy Maste & Details

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

Online Database for Inventory Management

Online Database application for inventory management is one of the most frequently demanded TeamDesk templates. The main goal of inventory management is tracking and organizing goods movement and making it more efficient. To achieve that, you should collect, register and analyze plenty of data, such as item/product names, models, serial numbers, quantity of goods, costs…

Online Database Inventory Control

Displaying Details in Generated Document

Document generation feature is very popular among TeamDesk online database customers. In connection to this functionality one of the most frequently asked questions is how to restrict a list of related details in a produced document template. This post provides instructions and examples of such an adjustment. Every generated document produces a formatted output of…