Firstly let me apologise for being a complete newbie when it comes to Access 2010. I've searched this forum (and several other forums) for an answer to this but I've been unsuccessful in my quest. Here's what I am trying to do. I have 3 tables in an Access database: Table1 has a list of people that I need to go through and check if they exist in tables 2 and 3. Table2 has all the people listed by first name and last name, along with a special ID. Table 3 has system account information of each person, for which I need to find each person in table1 and enter the corresponding "special ID" from table2 for each person found.
Since I have no idea how to automate this, I have been doing this manually but there are 8000 people to go through =(
Put simply, I am hoping to achieve something like, a loop through the surnames in Table1, Find a match in Table2 and matched get the "Special ID", Find the same surname match in Table3 and enter the "Special ID" into the specified field. Is this even possible?
I know I haven't provided much information here, and willing to do so, but can anyone help me with suggestions please? Thanks all.