98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Storing the unique ID
Storing the unique ID
Resolved · High Priority · Version 2016
Wed 29 May 2019, 19:10Delegate Manny said...
Manny has attended:
Access Intermediate course
Access Advanced course
Storing the unique ID
Hi Guys,
I know we can utilise the autonumber as a unique identifier. i intend to use this, however, in my database i will be having records being appending back and from tables, am i able to store the autonumber as a static field constantly? i.e. here would be the design
ID (auto)
StaticID (stored auto number)
So whenever this is appended or moved across, the ID will always be noted when it will enter the primary master table?
Manny
Wed 29 May 2019, 19:12Delegate Manny said...
RE: Storing the unique ID
almost like a master ticket reference. So I will be able to pull the entire audit history for a ID, no matter no how many time its auto number has changed hands?
Thu 30 May 2019, 10:12Trainer Jens said...
RE: Storing the unique ID
Hi Manny,
Thank you for the forum question.
You will need in the "new" table (the table you want to append the data to) to have a column which store the auto number from the source table and a primary key column in which you have the new autonumber.
I have created a tiny database (see attachment)
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Attached files...
Thu 30 May 2019, 10:23Delegate Manny said...
RE: Storing the unique ID
Hi Jens,
I can't see your attachment unfortunately?
Manny
Thu 30 May 2019, 10:25Delegate Manny said...
RE: Storing the unique ID
ah, i had something similar. i think it this should hopefully work fine!
Thu 30 May 2019, 13:27Trainer Jens said...
RE: Storing the unique ID
Hi Manny,
I hope that you have got the attachment. Sometimes it takes few minutes to be visible. If you in the future cannot see an attachment wait few minutes and refresh your browser.
I hope, that the solution works for you.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Create calculated fields that work out your ageYou can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field |
