P
Pete
I would like to create a composite primary key using two fields: a random
integer ID, and a "line number" index. I want the index to be incremental,
start with 1, and reset for each unique ID from the first field. For example:
ID INDEX
5127 1
5127 2
5127 3
6435 1
9921 1
9921 2
Is this possible in Access?
The context is a project management database. Each project has a unique ID.
Projects and their descriptions are stored in one table. Progress updates
are stored in a second table. I would like to be able to incrementally
identify the updates to for each project.
Thanks in advance for any help!
--Pete
integer ID, and a "line number" index. I want the index to be incremental,
start with 1, and reset for each unique ID from the first field. For example:
ID INDEX
5127 1
5127 2
5127 3
6435 1
9921 1
9921 2
Is this possible in Access?
The context is a project management database. Each project has a unique ID.
Projects and their descriptions are stored in one table. Progress updates
are stored in a second table. I would like to be able to incrementally
identify the updates to for each project.
Thanks in advance for any help!
--Pete