Orders Table:

USE [Database]

GO

/****** Object: Table [dbo].[orders] Script Date: 05/25/2010 22:52:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[orders](

[idOrder] [int] IDENTITY(1,1) NOT NULL,

[orderDate] [datetime] NULL,

[idCustomer] [int] NULL CONSTRAINT...

Thanks for squaring me away, I will revise my question.