Autofilling Masterfield on Subform Datasheet Lines

[pmontalt]

Hello,



I have a main form linked to a subform by the "ID" of main form. The subform is a datasheet that has line items. I want it so that every time a new record is created in the subform, the "Line" integer field auto increments from 1 and so on, such as the first line they enter would be 1, then the second be 2, etc. How would I go about doing this?

I've provided a screenshot. Right now I entered in the line numbers manually.



Thanks!!

[burrina]

If the 2 forms are linked correctly, then the data will display correctly.Does the subform have it's own table for the record source? If so then the record will have a counter using the Primary Key! The pic you have shown displays this, I am confused???

[pmontalt]

I entered in the Line numbers manually right now, I want it to be an auto increment field starting at 1 for each set of records associated with the current main form's ID, as in Job 371 would have line items 1,2,3 and when you go to Job 372, it would again begin from Line item 1 and so on.

There is a table that the subform is based on, it's own table TasksDNAAuthentication. It is a linked table from SQL Server.

[burrina]

This can be done using either the Primary Key or a Custom Counter. The table from the SQL Server should have it's own Primary Key and would of course auto increment.
If you want to use a Custom Counter, let me know and I can provide help with this.