Hi - sorry about this gumby question. I've tried all sorts of ways around this, but have hit the wall.
I'm trying to set up an equipment loan register - only a few tables, the two main ones are Equipment and Loans - both holding the asset number as a link field.
Problem is, I can't seem to get the pages generated by the wizard to include fields from more than one table (the table layouts and SQL string are below) - happens also with reports, but the additional fields can be seen on the order selection box in a report - ie trying to get Loans entry/list/etc screens generated to include fields from the Equipment table as well, but can only see the fields from the Loans table.
Am currently running PHPRunner 4.1 (Build 284) - have tried with 4.0 (265) and 4.1 (283) - on XP Pro - hitting MySQL 4.0.18-32 on a Suse 9 box.
Equipment table - set as a Master table
Asset Number VARCHAR 10
Status VARCHAR 10
Type VARCHAR 25
Manufacturer VARCHAR 50
Model VARCHAR 25
Location VARCHAR 50
Site VARCHAR 50
Department VARCHAR 50
User VARCHAR 50
Loans table - set as a Detail table and tick-box set to display master table on page
Asset Number VARCHAR 10
Staff VARCHAR 50
Date Out DATE
Date Due Back DATE
Date In DATE
Comments MEDIUMTEXT
ID INT
To Who VARCHAR 8
SQL for 'Loans' table
select `_Loans`.`Asset Number`,
`Staff`,
`Date Out`,
`Date Due Back`,
`Date In`,
`Comments`,
`ID`,
`To Who`,
`Status`,
`Type`,
`Manufacturer`,
`Model`,
`Location`,
`Site`,
`Department`
From `_Loans`
inner join `_Equipment` on `_Loans`.`Asset Number`=`_Equipment`.`Asset Number`
Any help very much appreciated.
Phil
