This custom field provides a dropdown of the site addresses for a customer
select distinct
ssitenum as [ID],
concat(sdesc,' ',Asline1,' ',Asline2,' ',ASLine3,' ',ASLine4,' ',Asline5) as [Display]
from Site
left join area on sarea=aarea
left join tree on treeid=atreeid
left Join AddressStore on AddressStore.assiteid = ssitenum
where
isnull(sisinactive,0)<>1
and isnull(AIsInactive,0)<>1
and isnull(ASInActive,0)<>1
and sarea = (select aarea from users left join site on usite = ssitenum left join area on sarea = aarea where uid = $userid)
ssitenum as [ID],
concat(sdesc,' ',Asline1,' ',Asline2,' ',ASLine3,' ',ASLine4,' ',Asline5) as [Display]
from Site
left join area on sarea=aarea
left join tree on treeid=atreeid
left Join AddressStore on AddressStore.assiteid = ssitenum
where
isnull(sisinactive,0)<>1
and isnull(AIsInactive,0)<>1
and isnull(ASInActive,0)<>1
and sarea = (select aarea from users left join site on usite = ssitenum left join area on sarea = aarea where uid = $userid)
