| |
| |
Here you will use NeXTensio Lists and Forms to represent a master-detail relationship between two of your tables.
The products you need in order to complete this tutorial are:
ImpAKT
NeXTensio 3
These two products are a part of the MX Kollection 3 bundle.
For this tutorial, the database A database refers to data organized and stored on a computer that can be searched and retrieved by a computer program. Most industrial-strength and many smaller database applications can be addressed using SQL (Structured Query A query is a SQL command that will extract information from the tables of a database. Essentially, a query is a request for information from your database. Language). to use is the one used in the Contact Management Tutorial. The tables used are company_com and contact_con. The company_com table is the master table, each contact belonging to a certain company.
During the creation of this little application, you will create four files:
master_list - storing the master table's listing of records.
detail_list - this displays the detail table list of records that match the selected master record A database row from the master table. The master table is defined by a one-to-many relation to another table (the detail table).
master_form - this is the form associated to the master table, allowing the insertion of new records.
detail_form - this form is related to the detail list, allowing you to insert data into the detail table, automatically linking it to the corresponding master field.
The files and the table structure can be found in the \tutorials\_HOW_TO\Master-detail relations\ folder.
To begin creating the site, open one of the pages, and create a database connection, relating to the table you created from the provided sql/mdb script.