Thanks Wayne,

Got it to work.

ProgID, ForeID, EAUID, Term, Year, Price

1, 1, 1, 1H, 2010, .50

1, 1, 1, 1H, 2011, .49

1, 2, 3, 1H, 2010, ..48

I understand. Hope this is what you are looking for.

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#CustProg','U') IS NOT NULL

...

who is asking you to write create table scripts? or create sample data? I thought I provided some generic sample data. I need to tweak the query I...

I'll try. not involving any creates or inserts so i will give you brief descriptions of the tables.

Forecast all:

FID# (key)

ProgID# (reference to master table)

Part Number

other irrelevant info

Pricing:

PID# (Key)

FID# (link...