>>Live NULL in the Item.HeaderID columnn for products. You can also add constraint that wouldn't allow to change it to anything else for products.
>
>Thanks Segey... But I'm not sure what you mean.
>Here's what I have....
>

>ALTER TABLE [dbo].[tbSpa_Item] WITH CHECK ADD CONSTRAINT [FK_tbSpa_Item_tbSpa_Header] FOREIGN KEY([spi_SpaHeaderID])
>REFERENCES [dbo].[tbSpa_Header] ([sph_SpaHeaderID])
>

>
>Should I move the products into a separate table?

>Frank,

>If you don't have a good reason to keep them in one table, than split it into two tables.

That's kinda what I thought....
Thanks again, as always.