I have an Access database with two tables.
They have 10741 and 12541 records respectively.
In the tables are two fields, one with the url to the file online, and one with a dropdown of UserNames+ID#s.
For each record where there is a file url, (their userid is part of the filen url), ? select the corresponding UserID/ID# from the dropdown list. This will fill in their ID#.
That's it, super easy.
## Deliverables
You will need Microsoft Access DB for this project.