G
Guest
I just CANNOT figure this out!
I have two tables. Table one is called HeaderInfo. Table 2 is called
DetailsInfo.
Within table HeaderInfo I have a field called RecordNum set as my primary key.
In table DetailsInfo I have a field called LogNum.
In my access relationships I set it so that there is a One-To-Many
relationship between the RecordNum field and the Lognum field. RecordNum is a
primary key.
I am trying to set it up so that for each record in table HeaderInfo, the
first field (RecordNum, which is set to AutoNumber) will, for example, put a
1 for the first record.
Consequently, I want each "detail" record (which are located in the
DetailsInfo table) to have a 1 in the LogNum field.
For record 2 in the HeaderInfo table (which would have a 2 under the field
RecordNum), there would be a 2 in the LogNum field for each record it
corresponds with in the OrderDetails table.
Is it the fact that I am trying to use an AutoNumber that is screwing this
up? I had it working before I switched it to AutoNumber. Please help.
Thanks.
I have two tables. Table one is called HeaderInfo. Table 2 is called
DetailsInfo.
Within table HeaderInfo I have a field called RecordNum set as my primary key.
In table DetailsInfo I have a field called LogNum.
In my access relationships I set it so that there is a One-To-Many
relationship between the RecordNum field and the Lognum field. RecordNum is a
primary key.
I am trying to set it up so that for each record in table HeaderInfo, the
first field (RecordNum, which is set to AutoNumber) will, for example, put a
1 for the first record.
Consequently, I want each "detail" record (which are located in the
DetailsInfo table) to have a 1 in the LogNum field.
For record 2 in the HeaderInfo table (which would have a 2 under the field
RecordNum), there would be a 2 in the LogNum field for each record it
corresponds with in the OrderDetails table.
Is it the fact that I am trying to use an AutoNumber that is screwing this
up? I had it working before I switched it to AutoNumber. Please help.
Thanks.