Hi Jack,

Thanks for the reply, this actually does the trick. 🙂

In response to your questions:

Your design allows for a many to many relationship between prop and item through the ItemProp...

Hi Jack,

I composed some DDL (since this was an imaginary example) and provided some data as an example.

/* ITEM */

CREATE TABLE ITEM

(

ITM_ID ...

Hi Jack,

In the link table I use foreign keys to ensure referential integrity. In thet PROPLINK table, the reference to the ITEM table is declared to cascade delete. When an...