Hello!! So, I'm trying to accomplish what the title states. In a nutshell:
I have a form that has a combo box called "Validation Type". This combo box is pulling this row source:
SELECT tblValidations.[Validation Number], tblValidations.[Validation Type (Short Text)] FROM tblValidations ORDER BY tblValidations.[Validation Number];
Upon updating the Validation Type '15' (other users will input 1 - 14 at different times), I want to find all records in the table "tblObservations" that have the same "Measurement Id" as the record I'm updating, but has a "Validation Type" of any of "1 through 14" (I'm updating validation type '37'), and I want to change the associated field "Cleared By", in all of the validation types 1 through 14, from Null to "Cycle Replaced" which is one of the options in the drop-down list that comes from "tblMasterContacts". This will allow me to omit them from all of my queries, since I already query for the "cleared by" to be Null.
The relationships between all of these tables are quite convoluted, since I was handed this database after it was built by two people, separately, who had no idea how to create a database. It's too late to go back, so I need to make this happen.
The purpose of changing these fields, is that I have a LOT of queries that pull these "validation types" that have "problem" associated with them, but the "cycle" (what year it happened) is not directly associated to the "Measurement ID" that I'm using to report the "problems" .
I'll be sitting here at my desk, having been emotionally demoted from Engineer to Database Administrator, anxiously awaiting help from anyone.
Please be aware that I, like my predecessors, know very little about databases.
Thanks!!