>maybe...it is definitely in a hierarchical relationship. Maybe it has never been named this within foxpro circles because we did not have a specific data type for this.
>
>>Hierarchichal Table?
>>
>>https://docs.microsoft.com/en-us/sql/relational-databases/hierarchical-data-sql-server?view=sql-server-ver15
>>

I agree with hierarchical table and I've written about dealing with them.

Wow, surprised to find this from 2006: http://www.tomorrowssolutionsllc.com/Articles/Querying%20Hierarchical%20Data.PDF

This one is about SQL Server: http://www.tomorrowssolutionsllc.com/Articles/Handling%20Hierarchical%20Data.pdf

This has a whole section on hierarchical data (though I suspect it mostly repeats the 2006 piece): http://www.tomorrowssolutionsllc.com/ConferenceSessions/Solving%20Common%20Problems%20with%20VFPs%20SQL.pdf

Tamar