2. PHPRunner General questions
  3. combining table data into one view layout
This topic is locked

combining table data into one view layout

 		3/27/2006 11:14:06 AM
PHPRunner General questions
Allenh author

I have three tables, data in the tables have a master-detail relationship, what I want to do is have one view layout combines all the content - how do I do this?
My tables are project_info, service2 & service3 - and preferablely I would want the view layout on project info to combine the information related to the specific project - is this possible?

Do I need to set up another table that combines all data?
Once again, thanks in advance for your help.
A.
prleo1 3/27/2006

AllenH,
I suggest creating a view that "Joins" the relevant fields together in all three tables. You might want to check the documentation in the most recent version. I do believe there is a blirb about joins and views.