This topic is locked
[SOLVED]

 Link FROM Detail TO Master

10/28/2020 6:17:53 PM
PHPRunner General questions
R
RBrogen author

Hi Everyone,
I have a Client view that displays detail links so you can hover over Orders link and see all of the orders for a specific client. This is accomplished using the Table Link Properties and displaying the details data on the master view page. The great thing about this feature is being able to click on the link and then it takes you to the Orders view filtered by the client you just clicked from. What I'm trying to add is a link from the Orders View page that allows you to click on and open the client record for that Order. I can't do this using the Table Link Properties because Orders is a Details page from the Master page Clients. Is there a way to manually create a link to the Master page from the details page? Any guidance would be greatly appreciated.
Thanks,

Randy

H
Hd_Mersintarim 10/29/2020

$value = "<a href='documents_list.php?mastertable=AdminEmployee&masterkey1=".$data["id"]."'>Employees</a>";
use table name and column name your actual

R
RBrogen author 10/29/2020

Thanks so much for the reply. What I'm trying to do is concatenate the client_ID_value with the a href so it links the column in the list. I think I'm close but am missing the syntax that will allow me to concatenate the items. I'm doing this on the EDITOR TAB in PHP Runner and I've tried &, &&, + and now the period but nothing is combining them together. Here's what I have for my client id column on my orders list:
<a href="https://studiosavvy.brogen.com/clients_list.php?q=(client_ID~equals~".{$client_ID_value}.")>"Test</a>;
Here is what it looks like in the view:


[https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=92871&image=2&table=forumreplies



$value = "<a href='documents_list.php?mastertable=AdminEmployee&masterkey1=".$data["id"]."'>Employees</a>";
use table name and column name your actual

R
RBrogen author 10/29/2020

I found a clean way to do it using #9 Custom option at the link below:
https://xlinesoft.com/phprunner/docs/view_as_settings_custom.htm