Forum Discussion

BradElmore's avatar
BradElmore
Qrew Assistant Captain
10 years ago

Create Relationships within same table and determine hierarchy level for each record.

I have a Product Table.....and within this table I have created a Relationship with itself.....and my look-up field is called "Parent Product"....for example I have 4 Product records (A, B, C & D)......
Branding and app management
Relationships
reports and charts
BradElmore's avatar
BradElmore
Qrew Assistant Captain
10 years ago
Mark, I was able to come up with a "limited" solution.....a solution where I'm limited to 4 hierachy levels....(limited because I did not want to create allot of new fields.....but it works.....thank you