Hi group,

I have 3 tables: tblOne, tblTwo and tblThree.

All of my items are stored in tblOne. However, based on the item-type
information must be added in either tblTwo or tblThree (not both).

Is there some way to force this behaviour? For example, when I try to add
an item with type 'Two' information has to be written to tblTwo?

Right now, my application enforces this logic but I would like to put
that responsibility in the database.

TIA,

SomeDude