Re: Tables with foreign keys to themselves don't maintain Lists of related rows.

2003-09-23 Thread Dave Newton
On Tue, 2003-09-23 at 16:54, Gary Baker wrote: > I've got a table with a foreign key to itself. I'm definitely not an SQL guru (I write printers, fer gosh's sake :) but... isn't a foreign key by definition a key in another table? Dave --

Tables with foreign keys to themselves don't maintain Lists of related rows.

2003-09-23 Thread Gary Baker
I've got a table with a foreign key to itself. Shouldn't the BaseXXX class maintain a List of related rows based on that foreign key... For example... Shouldn't there be a property on BaseXXX called collXxx of type List?? (there isn't one) Th