Greetings,
I'm entering data into a form with two associated subforms. One of the subforms is in a data table layout (if that matters), and I'd like get one of the data fields (numeric) to automatically populate in sequential numbers, specifically 1-50 (in 50 data rows/records), and then after 50, start over again at 1. This is similar to simply using an Autonumber field, however autonumber doesn't allow you to reset it back to 1 after reaching a specific value, in this case 50.
For more context, I'm a biologist working with vegetation sampling data collected using a line-point intercept method. For a given location (location is my primary key), there are two transects (i.e. lines) that have 50 data points associated with each of these transect lines. Each of the two transects has a label field "Transect ID", which can be one of two values- "Transect 1" or "Transect 2", and for each transect there are 50 "points" where data were collected, in a data field called "Point", and I'd like to have data records for the "Point" field auto fill sequentially 1 through 50 for each unique Transect ID.
Thanks for your help!