2. PHPRunner General questions
  3. Viewing fields in parent table from child table
This topic is locked

Viewing fields in parent table from child table

 		6/11/2008 3:13:31 PM
PHPRunner General questions
S
 SJWilson author

I have a database set up for a writer's articles. Each article fits under 3-5 categories. I have a table set up for the articles that has a lookup to another table set up for the categories. This is all working just dandy. The client also wants to list the categories and be able to click one to show the articles that are attached to that category.
At this point I figure anything can be done with PHPRunner so I'm not asking if it can be done anymore but could someone point me in the right direction on how to accomplish this one?
Thanks,

Susan
J
 		Jane 6/17/2008

Susan,
in general you can create custom link to the articles list page and filter it with selected category.

You can publish your project on the Demo Account (last tab in the PHPRunner) and send link to your pages to support@xlinesoft.com. I'll try to help you.
R
 		ramjamram 8/9/2008

I also have a similar issue now. I am wondering if the post here was answered and what the answer was. Basically, I have a query that includes a Primary Key (AgentID) with details. I have another query that pulls OrderedItems that has the FK AgentID. There could be many OrderedItems with details.
How can I make a list of the AgentID in a page and then when I click on the AgentID, it brings me to another page with the list of all OrderedItems for that AgentID.
Thank you.
J
 		Jane 8/11/2008

Hi,
I recommend you to set up master-detail relationships on the Datasource tables tab between your tables. Set up Agents table as master and OrderedItems table as detail.