Discussion created by MAKALENG on May 6, 2017
Latest reply on May 8, 2017 by philmodjunk

with this relationship Claims::Reffering Doctor = DOCTORS::SURNAME i easily get through lookup practicenumber problem is that there are other fields like admitting, treating doctors etc that must be looked up with each requiring new relationship, so i tried execute sql and it returns ?

i am missing something


ExecuteSQL ( "select DOCTORS::PRACTICENUMBER FROM DOCTORS WHERE Reffering Doctor = DOCTORS::SURNAME " ; "" ; ""  ;"" )