This topic is locked
[SOLVED]

 Newbie question

1/29/2010 10:20:23 AM
PHPRunner General questions
mcebula author

Hi all, I'm new around here. I'm considering PHPRunner for a department level intranet app I want to build for my group here at work. I'm not a developer but I work in the IT department on the analysis team so I know just enough to be dangerous <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=13657&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' /> but not enough to write a good sized web app from scratch myself which is why I'm happy to find code generator frameworks like PHPRunner. I've looked around at at a few others but PHPRunner appears to be the best choice for me with a good mix of functionality & support. With any framework that does a bunch of stuff for you I'm a little worried that I'll somehow get boxed into a corner. I will soon download the trial version to test it out on a small prototype but have a one high-level question.
My application is to manage IT artifacts to support our specs. Things like business data elements, error messages, business rules etc. Most are straight-forward tables or master-detail relationships which I'm pretty sure PHPRunner handles well. But I also need to maintain cross-relationships between most of the items which at the database level are just link/junction tables that have primary keys of the joined elements (many-to-many relationships). I'm a little worried the UI and if/how PHPRunner handles something like many-to-many relationships - drilling-down in master-detail relationship where the detail item has another table of information that needs to be displayed for a detail item.
Is there some way in PHPRunner to drill-down to that 3rd level information hanging off of a master-detail relationship? An example might be master table 'entity', detail table 'elements' - while viewing an element detail within it's master entity I'd like user to be able to see/manage what 'business rules' that are linked to that element (assume a separate link/junction table contains the relationship between entity-element and business rules).
Thanks for any information you can provide.

J
Jane 2/2/2010

Mike,
you can create two master-detail relationships. The first is entity->elements and the second is elements->entity.

To create a copy of each table for second relationships use Create custom view option on the Datasource tables tab.

mcebula author 2/5/2010

Does PHPRunner have the ability to display additional data in some type of popup window if I wrote custom SQL to read the linked data?

Sergey Kornilov admin 2/5/2010

You can create three-level Master-Details-MoreDetails relationships.
You have an option to show details in inline mode or in the popup. You can tweak details table SQL query if required using BeforeSQLQuery event.