I have field with that is assocaited with another field, when that field is selected I want to be able to bring that date back to another field

another issue, how would you get the date to not display a date if a check box is not checked

Select

client_id as Client,

ApplicantFullName as ClientName,

CounselorName as Counselor,

lastapptdatetime,

tdate,

TUDCounselor,

TDDate,

FUD1,

FUD2,

FUD3,

FUD11,

FUD21,

FUD31

From PDT_Counselor_CO_View

where coalesce (complete,0) <>1 or coalesce(tud,0) <> 1

and tdate >= dateadd(dd, datediff(dd, 0, getdate()) - 30, 0)

Order by client_id desc

This is my...