This topic is locked

Master Detail Issue

4/2/2009 7:27:38 AM
PHPRunner General questions
M
marke author

Hi
I have two tables - Simulations and Models
A model can be used for many simulations but a simulation can only use a single model.
I have configured the master detail relationship from model to simulations in PHPRunner with no problems at all.
Now I would like to add a link in the DataSource tables page to have the reverse relationship so that I can link from the simulation to the models list page with just the model that generated the simulation showing using a master-detail relationship but there would only ever be one detail record. I can't find a way on the datasource page to create two master-detail relationships between two tables (even though one direction is a 1:1).
Does anyone have a workaround for this?
thanks
Mark

A
alang 4/2/2009

Try creating a custom view on the tables page. You need to use this if you want more than one "view" of the same database table.

M
marke author 4/3/2009

of course
thanks Alan - I had forgotten that option