gargoyle60 wrote:
>>> Oops, that should read...
>>> ...
>>> FOREIGN KEY (parent_level)
>>> REFERENCES category (category_level)
Lew wrote:
>> So category (category_level) is a unique or primary key, then.
gargoyle60 wrote:
> Something like that,
It would have to be exactly like that or you wouldn't be able to point a
foreign key to it.
> probably with (category_level, category_code).
Then you'll need a two-column foreign key.
> Like I said, I never got around to implementing the provisional design and there may be more to it
> than that.
--
Lew
