In prior forms this worked automatically but now i have one case which always shows Detailpage.
![scriptcase master detail on new record scriptcase master detail on new record](https://i.ytimg.com/vi/OUio77S6kW0/maxresdefault.jpg)
Everything works fine exept that the Detailpage is shown first instead of the Gridpage with the master records for selection. Here is an example of a Master-details relationship between the Carsmake and Carsmodels tables, where the details table shows the models for the selected make. In AX 365 forms should use a design pattern. You can Add/ Edit the records of the linked tables on the same page in the generated app. In PHPRunner, you can join or link several tables that have at least one common field. Master-details relationships are commonly used in applications. Valued customers have several order records and often a user needs to view one table in connection with the other. As an example, we use the table order (for the form) and orderdetail (for the grid), making a scredir on the form, passing the primary key as a parameter and sending for the detail, that it's configured with scaplconf macro that will display only 1. Common examples of this relationship include customer/purchase data, patient/medical-record data, and student/course-result data.įor example, each customer (Master table Customers) is associated with at least one order record (Details table Orders). In this tutorial, we will demonstrate the use of macro scredir and we will also use the macro scaplconf.
![scriptcase master detail on new record scriptcase master detail on new record](https://i2.wp.com/crackoffice.com/wp-content/uploads/2020/03/maxresdefault-1.jpg)
Printing the master table data with the detailsĬharts and reports as master and details tablesĪ one-to-many relationship, often referred to as a "master-details" or "parent-child" relationship, is the most usual relationship between two tables in a database.
![scriptcase master detail on new record scriptcase master detail on new record](https://i1.wp.com/crackoffice.com/wp-content/uploads/2020/03/190Lv9B1P7NrD3uaKnAJFfG6eRFkaYIJ.png)
Setting up the Master-details relationshipĮxamples of the Table Link Properies options