Form/Subform Record Addition

[David1234]

Hi All,

I've been making a database, and for the life of me I can't remember something that I used to consider slightly basic :banghead:

I've got two forms, one header, one detail. When a user enters a record on the header it gives the ID (PK) field a No, when the detail is entered it replicates that number perfectly.....but, when there is an additional line to enter this is also the same number, surely it needs to increase where have i gone wrong!!!

 

[Uncle Gizmo]

Hi All,

I've been making a database, and for the life of me I can't remember something that I used to consider slightly basic :banghead:

I've got two forms, one header, one detail. When a user enters a record on the header it gives the ID (PK) field a No, when the detail is entered it replicates that number perfectly.....but, when there is an additional line to enter this is also the same number, surely it needs to increase where have i gone wrong!!!

What I think you are describing is a main form with a sub-form on it. The main form will have a unique ID and this ID Field will be duplicated against each record you add in the sub form. It has to be done like this because this is how access links the two items together, your record in the main form and then the "sub-items" you add to the subform.

In most cases you should not be able to see this linking reference number in the subform, and from what you are describing, a number which increases, then what you are describing is an auto-number field. You probably need to hide the "linking field" and un-hide the auto number field to make it work as you describe.

 

[David1234]

I knew it was something basic like that. I've gone back to two databases i've made before and now i've got a clear head it's all so clear that's what i've done before!!