Hello,
I have the following tables (simplified):
Instruments:
.... ID ............... # ....... primary key
.... Type ............. VARCHAR
.... Serial ........... VARCHAR
Users:
.... ID ............... # ....... primary key
.... Name ............. VARCHAR
History:
.... ID ............... # ....... primary key
.... Instrument_ID .... # ....... foreign key (Instruments.ID)
.... User_ID .......... # foreign key (Users.ID)
.... Startdate ........ DATE
.... Enddate .......... DATE
Maintenance
.... ID ............... # ....... primary key
.... Instrument_ID .... # ....... foreign key (Instruments.ID)
.... Repairdate ....... DATE
.... Repairprice ...... NUMBER
I like to achieve this result:
A list page for the instruments:
-----------------------------------------------------------------------
...... Edit ... View .. Info .. Type ...... serial
........ O ...... O ..... O ... Clarinet .. 89R35-678
........ O ...... O ..... O ... Trumpet ... 12345-678
........ O ...... O ..... O ... Trumpet ... 56276-78
-----------------------------------------------------------------------
If you click on the Info-button I like to show the next page:
-----------------------------------------------------------------------
Type: ... Trumpet
Serial: . 56276-78
History:
... Startdate .. Enddate .... Name
... 2000-04-01 .............. John
... 1999-01-01 . 2000-04-01 . Carl
... 1990-06-01 . 1999-01-01 . Mary
Maintenace
.... Repairdate ..... Repairprice
.... 2004-05-26 ......... $ 34.00
.... 2003-03-02 ........ $ 254.00
-----------------------------------------------------------------------
Can this be generated with PHPRunner or do I have to programm it myself.
If I have to programm it myself, how can I integrate standard layouts and styles from PHPRunner?
Greetings,
Jo van Duin[size="2"][/size]
