In this second episode, Getting Started with RDBMS, you will learn how to import data programmatically and how to link different tables to relate information effectively. This session introduces key relational database concepts that will be useful throughout your journey as a 4D developer. To follow along with this episode, you will resume the project created during Exercise 3 of Episode 1. Through this continuation, you will gain a deeper understanding of how data is structured, connected, and managed within the 4D environment, building the foundation for more advanced data manipulation in future lessons.

In this third episode, First Form, First Query, you will learn how to create a data presentation form and perform your first data queries in 4D. To get started, use the application located in the “ProjectManagement” subfolder and move it into the Episode 3 folder — this version corresponds to the state of the project at the end of Episode 2. This session will guide you through the process of designing your first form and exploring how to query data effectively, allowing you to visualize and interact with information within your 4D application.

In the previous episode, we explored how to use menus in 4D, display a list box, and perform queries. In this fourth episode, Add & Delete, we will take the next step by improving our interface and defining two key actions to add and remove items from the list box. This episode gives users the ability to create their own data rather than simply importing it, reflecting the typical behavior of a real-world application. To follow along, open the application located in the “ProjectManagement” subfolder and move it into the Episode 4 folder — this version represents the project’s state at the end of Episode 3. You will also need to use the “resources” folder, which contains the required assets such as images referenced throughout this episode. During this session, you will learn how to manipulate data directly through the interface by creating two custom action buttons — Add and Delete — and linking them to the appropriate processing code, making your 4D application more dynamic, interactive, and user-friendly.

In this fifth episode, Display in Details, you will learn how to view all the relevant information related to a list box element. At the end of the previous episode, we explored how to manipulate data through the interface; now, we will focus on displaying detailed information from the Company table. This will allow you to visualize specific details about a company, particularly the comments associated with it. As you move forward through the upcoming episodes, additional fields will be introduced to enrich the data display. To follow along, open the application located in the “ProjectManagement” subfolder and move it into the Episode 5 folder — this version represents the state of the project at the end of Episode 4. This session will help you understand how to make your interface more informative and user-friendly by revealing the full context of your data.

In this sixth episode, Improving the User Interface, you will focus on refining the design and visual composition of your 4D application’s graphical interface. Using 4D’s built-in editors, you will learn how to enhance the overall look and feel of your application to create a more intuitive and visually appealing user experience. To follow along, open the application located in the “ProjectManagement” subfolder from Episode 5 — this version represents the state of the project at the end of the previous episode. This session will help you understand how to take care of interface elements and graphical objects, ensuring your application is both functional and aesthetically well-designed.

The objective of this episode is to allow the user to save the changes made to a record. To do this, take the application located in the **"ProjectManagement"** folder, which corresponds to the state of the project at the end of episode 6. In this episode, we will learn how to manage a company’s update.

In this eighth episode, Display Linked Data, you will learn how to display data from a related table by leveraging the relational structure of the database. At the end of the previous episode, we explored how to manage different viewing and editing modes, as well as how to modify a company’s data through a form. Now, we will build on that foundation by displaying a list of employees working in a selected company within the same form. To follow along, open the application located in the “ProjectManagement” folder from Episode 8 — this version represents the state of the project at the end of Episode 7. This session will help you understand how to connect and visualize related data efficiently, providing a more complete and interactive view of your business information within 4D.