It looks like you should decompose your Category - Item relationship into 2 m:n relationships

Category - LinkTable - Category
Category - LinkTable - Item

--
Matthias Laube
[EMAIL PROTECTED]

Ollie Rutherfurd wrote:

Hi,

I'm trying to setup an M:N mapping, however I can't follow the examples in the tutorial, as I've got a twist. Here's what the relationship looks like:

Category <-> LinkTable <- Item

The hitch is that rows in LinkTable may either refer to rows in the Item
or Category table (depending on a column value). In otherwords, Category may contain 0 or more Categories as well as 0 or more Items. Both Category and Item may be contained by 0 or more Categories.


If anyone had any suggestions or pointers on how to best achieve this type of mapping, I'd really appreciate it!

Thanks,
-Ollie




--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to