I have id key relationship between a workout table (parent) and a sets table (child) -- workoutID is the common id.

I need to modify code (incCommon.php table list I think) so that the sets table does not display on the main menu/ index page.

Instead, I want to be able to access sets_info_view.php from a button on the detail view within workout_info_view.php using the common id.

I am really having trouble tracing the variables from one php file to the next to do this. I have created the button and have it showing on the detail view (see attached workout_info_view.png).

Attached Images

 

Did you edit the button link to go to sets_info_view.php page?

If the answer is to add an onclick event, how would that look? I tried...

$templateCode=str_replace('<%%WORKOUTSETS_BUTTON%% >', "<input type=image src=workoutsets.gif vspace=1 name=workoutsets alt='" . $Translation['workout sets'] . "' onClick=\"location.href='sets_info_view.php' ;\">", $templateCode);

..for the new button, but it does not work.

BTW -Where is the code that sets the url that we see in the status bar when we hover over the buttons in a detail view? I don't see an onclick set for anything but the delete row warning.

You may want to take a look at your generated *tablename*DV.html file.

I have tried Firefox Firebug to trace the code for the detail view buttons. I am guessing, but...

...it looks like form action starts in datalist.php and refers to constructor variable "ScriptFileName" which is set in ~view.php. Also the functions for each button are in ~dml.php in insert, delete, deselect. So maybe I want to make a function that will override the form action to activate to the ~child_view.php rather that the ~parent_view.php.

Can someone give me any hints for where to start.

It can work, but it has to be coded as a link..

$templateCode=str_replace('<%%RES_LIST%%>', "<a href=\"page_nave_view_list.php\" target=\"_blank\"> <img src=\"image-name.gif\" border=\"0\" alt=\"Txt on hover\" /> </a>" , $templateCode);

Draw back is that if you have to send a variable, it has to be sent via get - since I could not get the <input type=image to work. Even with a window.open...