2. PHPRunner General questions
  3. following up 'Master Detail Problem, Now I am lost' post fro
This topic is locked

following up 'Master Detail Problem, Now I am lost' post fro

 		2/4/2007 6:07:21 PM
PHPRunner General questions
M
 marke author

Hi
I really like the 207 build - big improvement.
I have been trying to update an existing PHPRunner application which contains around 20 projects. About half of these use master-detail relationships where a table links back to a 'people' table using the Primary key in the people table as the foreign key. I know this not necessarily good practice - but it has worked fine for the development and I don't really want to have to rework the whole application at this stage. Is there a way round the fact that the detail list doesn't even show the primary key of the selected table as a greyed out option.
thanks
Mark
Alexey admin 2/5/2007

Mark,
PHPRunner denies selecting AUTO_INCREMENT fields as a foreign key.

This is a bad practice and wouldn't work properly in most cases.
To build your project remove AUTO_INCREMENT flag from your people table key.

Then open your project in PHPRunner and build the pages.

Add AUTO_INCREMENT flag back if you need it.
M
 		marke author 2/5/2007

Alexey
Thanks - I can use that as a workround until I find a better solution.
Mark