2. PHPRunner General questions
  3. Design Question
This topic is locked

Design Question

 		9/16/2008 12:51:39 AM
PHPRunner General questions
bbarker author

Three tables: Owners, Cars, Awards
When linked as THREE tiers, Owners -> Cars -> Awards, it works well.
---PROBLEM---

When I'm viewing/editing at the lowest level CARS (Master) and AWARDS (Details), it doesn't show who the owner is? I need to show (Owner AND Cars) when Awards is the Detail.
What's the best way to do this? How can I effectively show three tables as only TWO tiers.
---EXAMPLE---
How can I show this? (and edit it)
OWNERS (master), CARS (details)

and then

OWNERS/CARS (master), AWARDS (details)
---OR---
OWNER-A

!CAR1

........! AWARD1

........! AWARD2

!CAR2

........! AWARD1

........! AWARD2

........!__ AWARD3
I was hoping that V5 would have made this easier... Maybe it does, but I couldn't find it.

Or, should I be added a new VIEW table?
Appreciate any suggestions.
J
 		Jane 9/16/2008

Bill,
I recommend you to use reports for this purpose.
bbarker author 9/16/2008

Bill,

I recommend you to use reports for this purpose.


That works fine for "viewing"...
But when the authors are "editing", they lose track of who the owner is since the first table isn't shown.
Is there any way to show "Owner" and "Cars" when you are editing the "awards" table?
T
 		thesofa 9/16/2008

you could make a View of the owners and Cars and make the Awards table a detail table to the custom view., then when you click on show mater table details on the detail page, you could see both.
bbarker author 9/16/2008

you could make a View of the owners and Cars and make the Awards table a detail table to the custom view., then when you click on show master table details on the detail page, you could see both.


I tried that. Made a Custom View with Owners and Cars... but then was not able to make Awards a detail screen. Couldn't figure any way to do that.
T
 		thesofa 9/17/2008

post the MySQL dump of the table structures and we can all have a play
J
 		Jane 9/17/2008

Bill,
you can print data from Owner and Cars tables on teh edit page of Awards table using custom events (Insert PHP code snippet option on the Visual Editor tab).

Check Show list of customer orders sample event in the PHPRunner Help.