I've two tables on my app and I'd like to place a status on one column if the item exists in the other table.
In this case, I want to flag "Attention" if the "Ent code" in tblMyEntities exists in the "Entity mf code" on the past submissions table.
I could probably achieve this in other ways but I like how the statuses represent themselves and it seems like a logical way to do things in this example.
I'm just struggling in understanding how to map between the two.
Thanks for your help!