Create custom temporary table with data from two tables and insert record in third table

Syntax

New member
Hello, I'm new to dadabik and still evaluating it.
Do you have an example to show how I can generate a list of items taking the data from 2 tables, and insert the form result in a third table ?
I want to do a scheduled devices maintenance system, this is the description of my project :
Table 1 = list of all devices with maintenance schedule
Table 2 = List of tests to be done, depending on device type
A temporary table (Maintenance in progress) is created with the device ID, description, ... (from table 1) and the list of tests that have to be carried on the device (from table 2), plus other data (date/time, user ID, ...)
Every time that a device is tested (form based on temporary table), the test result is written in Table 3 (maintenance data), and the current line is removed from the temporary table.

Do you have an example or tutorial showing how I can do this with Dadabik ?

Thanks in advance for your help.
 
Top