Self-Referencing Keys

Hey guys,

I was wondering f anyone has used Blazor Studio with self-referencing keys? For instance, if I have an animals table, then, in that table I also have FK’s to mom and dad id numbers.
If there’s a better way, I’m all ears to receive. Basically, when viewing or adding a new animal I want to be able to select, from a dropdown to whom the animals are related to.


Northwind Employees table is exactly such.