![master detail buttons php maker master detail buttons php maker](https://phpmaker.dev/doc/images/detailpreview.png)
Click the dropdown button and then click Master/Detail View, Master/Detail Edit or Master/Detail Copy to view/edit/copy and selected record and its detail records. Click on the "orderdetails" button to access the order details for Go to the Generate tab, click the Generate button to generate scripts.Ĭlick on the link to the "orders" table, there will be a newĬolumn for the "orderdetails " table.
![master detail buttons php maker master detail buttons php maker](https://wpdatatables.com/wp-content/uploads/2021/05/table-tools-export-buttons.png)
If you have the Preview extension (for registered users only) and want to enable detail record preview by Ajax, you can click Tools -> Extensions to enable it. By default each detail table occupies a column in the main table of the List page, if Multiple detail tables is enabled, the columns will be combined as one. If the master table has more than one detail tables, you can choose Multiple detail tables. If you want to enable Master/Detail-Add, Master/Detail-Edit and/or Master/Detail-View, enable them for the detail table in the Table Setup page: If you want referential integrity, you can enable Referential Integrity, Cascade Delete and/or Cascade Update, see Table Setup -> Master/Detail for detail. In this example, we have only one master/detail relationship, so we click OK to confirm. Multiple master/detail relationships are supported, if the table has other master tables or detail tables, just repeat above process. In this tutorial, we only have one detail field (orderdetails.OrderID) and one master field (orders.OrderID). If there are more linked field, repeat the step until all the relationships are setup. Then create a relationship between them by dragging from the master field (key field in master table) to the detail field (foreign key field in the detail table). Drag the detail table from the table list on the left to the diagram on the right. to bring up the master/detail relationship editor. Then in Master/Detail panel at the bottom right corner of the page, click Modify. The Table Setup page is displayed in the right pane. In this example, we choose the master table - "orders" Select either the master or detail table in the Database tree view (the left pane). Open PHPMaker and connect to the demo database. We will set up the master/detail relation between these In the demo database, there are two tables called "orders" and "orderdetails".
#Master detail buttons php maker how to#
In this tutorial we will show you how to setup Master/Detail tables.