I then spent a couple weeks writing code that would allow me to query those files for records with specific IDs and cross-reference those IDs with information on other files.
You know, just like a database does. Only slower, probably buggier, and with no real ACID compliance. Whoever came after me must have thought that I was an idiot.