Forum Discussion

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

_anomDiebolt_

Qrew Elite

10 years ago

I am not saying it can't be done but it isn't going to be easy and there will be a lot of limitations. Modeling things like Bills of Materials or Chart of Accounts which are hierarchies are notoriously difficult even in SQL.

Joe Celko's Trees and Hierarchies in SQL for Smarties
http://www.amazon.com/Hierarchies-Smarties-Edition-Kaufmann-Management/dp/0123877334

Forum Discussion

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

Related Content

Cross App Relationships

How to Link Tables in a Complex Many-to-Many Relationship?

Relationship - Forms

Help connecting Table to Table Relationships

App-to-App Permissions/Relationships