To learn about creating Master/Detail controls, please click here.

A master/detail set involves the linking of two database tables. Consider the following: you run a services directory using your application server, with a table giving a list of suppliers. There is a table where more detailed information about each supplier is stored, with an item in both tables having the same value.

The first table is the "master" table, where a supplier can be looked up in the second to provide more detailed information - hence this is the "detail" table. ScriptWorx can create an HTML link which acts as a data field on your master page, which links to the second table by using a linked field.

Supplier Table (Master)
No	Name	Tel	Web
0001	C Heeky	069 69 69	...
0002	W Astenot	070 70 70	...

Profile Table (Detail)
Detail	No	Employees	Address
555	0001	12	1 Anyroad..

Creating a master/detail set in this instance would require the linking of the "No." fields, as the second provides more information. ScriptWorx can quite easily create master/detail pages using ADO, ODBC or even MySQL.