Hi I have these 3 tables,
a layout based on training course has a popover with global fields. One such is g_Name, which I have put as a drop down list of Staff::Name. I want to check if what is either entered or selected in this field exists as a Staff::Name in the staff table. So what I'm asking is how best to perform the find.
As part of the script , to find, I'm currently doing,
But it never seems to find a match, even when the value of g_Name is from the drop down list I mentioned earlier which is made up of values from the staff table.
Thanks in advance