This topic is locked

More Details on View Page.

4/5/2008 10:35:09 AM
PHPRunner General questions
S
swanside author

Hello.
I have a customer Table, and Job Table. I tie them together as follows.
Job is the main menu, On the jobs I have a link to the customers, but, How can I move this link and put it on the view page for the jobs, instead of on the main page for the jobs.?
Cheers

Paul.

J
Jane 4/7/2008

Paul,
use custom event (Insert PHP code snippet option on the Visual Editor tab) for this purpose.

Here is a sample:

global $conn;

$strSQL = "select LinkedField from MasterTableName where RecordID=".$_REQUEST["editid1"];

$rs = db_query($strSQL,$conn);

if ($data = db_fetch_array($rs))

echo "<a href=\"DetailTableName_list.php?mastertable=MasterTableName&masterkey1=".$data["LinkedField"]."\">DetailTableName</a>";