i am having trouble matching my table row number to my report page number. On my table i set a column to autonumber which i use so when i am in a report the report page number matches the information i have in the table. ex. row 1 in my table would be page number 1 in my report. the issue is that when i add new rows to my table it throws my page number out of sync.
access report
- Thread starter je5903
- Start date
Dennisk
AWF VIP
- Local time
- Today, 05:49
- Joined
- Jul 22, 2004
- Messages
- 1,648
1). Autonumbers are meant to be unique and not consecutive. If a row is deleted the that autonumber is not reused.
2). As Autonumbers are meaningless in that the value has no correllation to the data, they should only be used internally to link tables.
3). NEVER expose the autonumber to users. here is why.
I had a corrupted database and the only way to recover was to use a third party tool.
However autonumbers where converted to numbers so I had to re-generate the autonumbers and update the FKs in all the related tables. However the users had used the autonumbers on patients case notes, and they did not always agree anymore. If you require an autonumber that is exposed to the user then you will have to generate it yourself.
2). As Autonumbers are meaningless in that the value has no correllation to the data, they should only be used internally to link tables.
3). NEVER expose the autonumber to users. here is why.
I had a corrupted database and the only way to recover was to use a third party tool.
However autonumbers where converted to numbers so I had to re-generate the autonumbers and update the FKs in all the related tables. However the users had used the autonumbers on patients case notes, and they did not always agree anymore. If you require an autonumber that is exposed to the user then you will have to generate it yourself.
okay what i am trying to do is i ran a report in excel and dropped it in access. i generate a letter which is in my report tabs which contains data from my excel/access table. As i enter new details in my table this should match my page number in my report tab on the bottom. so i can just type in the page number and the corresponding letter matches the row in my table
