Trouble with lookup record in table: need help troubleshooting

I'm having trouble getting lookup record to work in this table can you tell me what I might be doing wrong? Thank you!!!

David K.
·
·
https://app.clay.com/workspaces/7778/tables/t_usIc3cnMng1Y/views/gv_fQlNsLmi5blo
Clay Team
APP
·
·
LuisArturo, do you have some time to jump in here and check? :)
LuisArturo
·
·
Sure let me take a look.
David K.
·
·
Thank you
Clay Team
APP
·
·
Got it to run your column David, it looks like you might have accidently clicked the wrong column in the "Target Column" option. Look Up Record needs to search for matching values in two different tables. You selected Sale Nav Company Link on this table, but clicked option FINAL- Sled Customer Assistance on the other, which happened to be below the one you were looking for.
David K.
·
·
Ahh thanks LuisArturo did you update that for me?
David K.
·
·
it looks correct now
LuisArturo
·
·
Yes I did make that change for you.
David K.
·
·
thank you!
David K.
·
·
that worked and when I update something in the other table that new information will move over to this table?
Clay Team
APP
·
·
Sorry for the delay, no you would need to re-run the "Lookup Record" to fetch the new data
David K.
·
·
ok makes sense thansk!