create a hierarchial table structure

I have a simple account table.  How do you create a hierarchial table structure for accounts that just goes 1 level deep?

So, you can have a parent account and then child accounts underneath the parent.

Thanks for any help.
Regards.
-Dman100-Asked:
Who is Participating?
 
ianmills2002Connect With a Mentor Commented:
Two options.

1. A 2nd Parent account table and all the accounts in the account table have a foreign key to link to the parent.

2. Keep them all in the same table and add a Parent Account column. When NULL, the account record is a parent, when NOT NULL, the account has a parent account.
0
 
-Dman100-Author Commented:
Thank you!
0
All Courses

From novice to tech pro — start learning today.