sql1 - guest --- this will work if guest of is ALWAYS populated

(select top 1 prt_sponsored_by
from prt
where
prt.prt_guest_of = Prt.Prt_Name)

---------------

in formula

if {@guestof} <> '' then
{@guestof} else
{Prt.Prt_Sponsored_By}