2. PHPRunner General questions
  3. Display master table info for multiple tables
This topic is locked

Display master table info for multiple tables

 		12/30/2007 7:45:17 PM
PHPRunner General questions
D
 dmcconnell author

Is it possible to display the master table info for multiple tables? I have three tables:
licenses

products

usage
products relates to licenses

usage relates to products
When I am on the licenses table and drill down to the products table, the licenses table info shows up at the top of the page, If I then drill down to the usage table, the products table info show at the top of the page. Is there any way to have the licenses and products table info show up at the top when drilled down to the usage table?
Thanks,

David
D
 		dmcconnell author 1/1/2008

Anyone? Any ideas?
Sergey Kornilov admin 1/3/2008

David,
you can use "Insert PHP code snippet" function in Visual Editor to write a piece of code that displays license info while you are on the Usage page.
S
 		swanside 1/3/2008

Is it possible to display the master table info for multiple tables? I have three tables:

licenses

products

usage
products relates to licenses

usage relates to products
When I am on the licenses table and drill down to the products table, the licenses table info shows up at the top of the page, If I then drill down to the usage table, the products table info show at the top of the page. Is there any way to have the licenses and products table info show up at the top when drilled down to the usage table?
Thanks,

David


You could make a custom view using the inner join command, not too sure about itmyself, as I am just starting to learn it, but, if you have something like licenceID and it refers to the information on the licenses, products and usage table, you could do something like

select licenses.(whatever fields),

products.(whatever fields),

usage.(whatever fields)

from licenses inner join products

on (license.licenseID= product.licenseID)

inner join usage

on (license.licenseID= usage.licenseID)