>>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.
Thank you,
- Frank