I've used PHPR for all sorts of neat projects, but I'm looking for suggestions from the Community of this one.
I have a MS-SQL 2008 table that has many rows which contain basic fields like Master_Part and Child_Part.
These parts can consist of many levels; ie:
Part Automobile (Master)
Part Engine (Child)
Part Engine (Master)
Part Distributor (Child)
Part Distributor (Master)
Part Rotor (Child)
etc... any master can have many children.
I've set up a recursive SQL query that will pull this info together for me in levels (Auto, Engine, Distributor, Rotor) as 0,1,2,3.
That works well when just using a SQL command line. I now am looking for a good way to represent this same information using PHPR (maybe using Advanced Search for the 'root' part).
I thought about creating 5 or 6 copy views on the same recursive query and then associating them Parent->Child in PHPR.
Any comments or suggestions would be welcome. Thanks!
Jake