I have a master table that contains 15000 cases. Lets call it the "Master Table" This master table was split into about 150 smaller tables. ("Table1" to "Table150"). I have a unique field called ("ID")
What I want to do is:
I have created an addition field in my "Master Table" called "Table Name". Now I want to use an update query (or any other means possible) to update this field with the smaller table name (Table1 / Table2 / ....../ Table150) into which the specific case was divided. Is this at all possible?
I can do it table by table but this will take too long.
I'm don't use access a lot so this might sound dumb.