Please can any one help?
I have two tables a Header and a Detail Table.
The header table has a PK called Forecast_No
This has a foreign key relationship with a concantonated
primary key in the Detail table consisting of the
Forecast_No and a Forecast_Line_No.
Header.Forecast_No = 1
Detail.Forecast_No = 1 +
Deatil.Forecast_Line_No = 1
The problem I have is how to have the Forecast_Line_No as
part of the primary key but to reset its auto-increment
for every new Forecast_No.
In this way I can create the master detail relationship I
am looking for and the Detail information ...