Entry

PHPRunner: Table: How to create a hyperlink from a master table to its detail tables?

May 29th, 2005 05:19
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden --- 19 May 2021 - 09:32 pm ------------------------
PHPRunner: Table: How to create a hyperlink from a master table to its 
detail tables?
---
Steps: Overview:
 1. -Create your master-detail tables in MySql
     1. Create a master table with a primary key field
     2. Create one or more detail tables with
        its foreign keys pointing to the primary
        key field of the master table
 2. -Open PHPRunner
 3. -Open your database
 4. -In the step screen 'Datasource table'
     1. -Choose your tables
         1. Choose your master table
            1. -Indicate as 'master' table
                 <NONE>
         2. For each of the detail tables
            1. -Indicate their master tables
                1. -Indicate their primary key
            2. -Indicate their foreign key
            3. -If you do not want to see an entry
                for this detail table,
                disable the checkbox
                [ ] 'Create menu item for this table'
                (you could thus choose to disable this
                 option for all detail tables, and
                 only enable it for the master table.
                 This because you should know the
                 primary key of the row of the master
                 table if you add entries in any of the
                 detail tables. By forcing to add only
                 via the master table, you might accomplish
                 this)
            4. -To see on the detail page the
                currently selected master row
                information
                enable the checkbox
                [x] 'Display master table info in the detail page'
 5. -Build your project
 6. -View your project in the browser
     1. -When you now goto the master table you will see that it has
         included hyperlinks to each of its detail tables.
         1. To have the current primary key of
            that record in the master table linked
            to a new detail table entry
            1. Click on that detail table hyperlink
            2. Click 'Add new' in that detail table
            3. Then that master table record
                (with its primary key, e.g. 1001) is
               connected to that new detail table record
---
---
Internet: see also:
---
Database: MySQL: Table: Master: Detail: How create master detail table 
MySQL? [foreign key / InnoDB]
http://www.faqts.com/knowledge_base/view.phtml/aid/34396/fid/183
---
Database: MySql: PHPRunner: Table: Split: How to possibly divide 1 
large table in smaller subtables?
http://www.faqts.com/knowledge_base/view.phtml/aid/36333/fid/1805
---
Database: MySql: PHPRunner: Link: Can you give an overview of links?
http://www.faqts.com/knowledge_base/view.phtml/aid/35950/fid/1805
----------------------------------------------------------------------