I have a large database that has sporadic fields with incomplete or missing data. Quite the inherited project, I have to say. I'm new to Access, so if you have any ideas on how to simplify this pile of awesomeness, I'd love to hear them. Here's a bit of a primer on my situation:
Columns in tblMaster(yes, it's a mess. Manufacturing what we do uses a lot of parts):
Columns in tblDescriptions:
This sprawls over thousands of records. The problem is that the table of descriptions was incomplete when it was initially imported from Excel, and thus there's a ton of records in the main table with missing descriptions. I have since updated the descriptions table information to include everything that was missing previously. My entry form uses the updated information just fine, but the stuff prior is incomplete. Here's what the tables look like. tblMaster has columns for the fitting IDs, though they're not in the screenshot.
My question is this: If each of those fitting columns in tblMaster is a separate fitting, how do I match each of those IDs to their respective descriptions in the other table and update the main table with the completed information? I've been looking all over the place on how to do this; All I've seen is stuff on lookup tables and I don't want to use those for obvious reasons. I'm about to scrap it and start over.
I would greatly appreciate any input on this.