2. PHPRunner General questions
  3. Report with details
This topic is locked

Report with details

 		11/13/2008 4:04:59 AM
PHPRunner General questions
W
 webdino author

Hello,
I want to create a report with some Details from another table like this

from a table with name Auftragskoepfe
Table Auftragskoepfe is like this:

ID Description Date owner

1 alkdfjdjfkl 2008.11.01 100

2 jjjjjjjjjjjjjj 2008.11.05 101
now I want to create a Link on the ID to see the Details from the Table Auftragspos.

The Details are in the Table Auftragspositionen and the key ist the ID.
Auftragspos

ID owner Artikel volume delivery

1 101 444 1 2008.11.05

1 101 522 1 2008.11.05

1 101 321 1 2008.11.05

1 101 100 1 2008.11.05

...
J
 		Jane 11/14/2008

Hi,
set up ID field as custom on the "View as" settings dialog on theVisual Editortab.

Here is just a sample:

$value = "<a href=\"Auftragspositionen_list.php?a=search&value=1&SearchFor=".$value."&SearchOption=Contains&SearchField=ID\">".$value."</a>";