<style>p { margin: 0; }span.fr-emoticon.fr-emoticon-img { background-repeat: no-repeat !important; font-size: inherit; height: 1em; width: 1em; min-height: 20px; min-width: 20px; display: inline-block; margin: -0.1em 0.1em 0.1em; line-height: 1; vertical-align: middle; } span.fr-emoticon { font-weight: normal; font-family: "Apple Color Emoji", "Segoe UI Emoji", "NotoColorEmoji", "Segoe UI Symbol", "Android Emoji", "EmojiSymbols"; display: inline; line-height: 0; } blockquote { border-left: solid 2px #5e35b1; color: #5e35b1; margin-left:0; padding-left:5px;}blockquote blockquote{ border-color: #00bcd4; color: #00bcd4;}blockquote blockquote blockquote{ border-color: #43a047; color: #43a047;} table.grid{ border-collapse: collapse;} table.grid td, table.grid th { border: 1px solid #ddd;} .fr-fic.fr-dib{ display: block; margin: 5px auto;}.fr-fic.fr-dib.fr-fir{ text-align: right; margin: 5px 0 5px auto;}.fr-fic.fr-dib.fr-fil{ text-align: left; margin: 5px auto 5px 0;}.fr-fic.fr-dii{ float: none; margin: 5px auto;}.fr-fic.fr-dii.fr-fil{ float: left; margin: 5px auto;}.fr-fic.fr-dii.fr-fir{ float: right; margin: 5px auto;}img.fr-dib.fr-fir { margin-right: 0; text-align: right;}img.fr-dib.fr-fil { margin-left: 0; text-align: left;}img.fr-dib { margin: 5px auto; display: block; float: none;}img.fr-bordered { box-sizing: content-box; border: solid 5px #CCC;}img.fr-shadow { box-shadow: 10px 10px 5px 0px #cccccc;}img.fr-rounded { border-radius: 10px; -moz-border-radius: 10px; -webkit-border-radius: 10px; -moz-background-clip: padding; -webkit-background-clip: padding-box; background-clip: padding-box;}</style><p>This custom field provides a dropdown of the site addresses for a customer</p>
<style>p { margin: 0; }span.fr-emoticon.fr-emoticon-img { background-repeat: no-repeat !important; font-size: inherit; height: 1em; width: 1em; min-height: 20px; min-width: 20px; display: inline-block; margin: -0.1em 0.1em 0.1em; line-height: 1; vertical-align: middle; } span.fr-emoticon { font-weight: normal; font-family: "Apple Color Emoji", "Segoe UI Emoji", "NotoColorEmoji", "Segoe UI Symbol", "Android Emoji", "EmojiSymbols"; display: inline; line-height: 0; } blockquote { border-left: solid 2px #5e35b1; color: #5e35b1; margin-left:0; padding-left:5px;}blockquote blockquote{ border-color: #00bcd4; color: #00bcd4;}blockquote blockquote blockquote{ border-color: #43a047; color: #43a047;} table.grid{ border-collapse: collapse;} table.grid td, table.grid th { border: 1px solid #ddd;} .fr-fic.fr-dib{ display: block; margin: 5px auto;}.fr-fic.fr-dib.fr-fir{ text-align: right; margin: 5px 0 5px auto;}.fr-fic.fr-dib.fr-fil{ text-align: left; margin: 5px auto 5px 0;}.fr-fic.fr-dii{ float: none; margin: 5px auto;}.fr-fic.fr-dii.fr-fil{ float: left; margin: 5px auto;}.fr-fic.fr-dii.fr-fir{ float: right; margin: 5px auto;}img.fr-dib.fr-fir { margin-right: 0; text-align: right;}img.fr-dib.fr-fil { margin-left: 0; text-align: left;}img.fr-dib { margin: 5px auto; display: block; float: none;}img.fr-bordered { box-sizing: content-box; border: solid 5px #CCC;}img.fr-shadow { box-shadow: 10px 10px 5px 0px #cccccc;}img.fr-rounded { border-radius: 10px; -moz-border-radius: 10px; -webkit-border-radius: 10px; -moz-background-clip: padding; -webkit-background-clip: padding-box; background-clip: padding-box;}</style><div id="isPasted" style="color: #000000;background-color: #fffffe;font-family: Consolas, 'Courier New', monospace;font-weight: normal;font-size: 14px;line-height: 19px;white-space: pre;"><span style="color: #0000ff;">select</span><span style="color: #000000;"> </span><span style="color: #0000ff;">distinct</span><span style="color: #000000;"><br></span><span style="color: #000000;">ssitenum </span><span style="color: #0000ff;">as</span><span style="color: #000000;"> [ID],<br></span><span style="color: #c700c7;">concat</span><span style="color: #000000;">(sdesc,</span><span style="color: #ff0000;">' '</span><span style="color: #000000;">,Asline1,</span><span style="color: #ff0000;">' '</span><span style="color: #000000;">,Asline2,</span><span style="color: #ff0000;">' '</span><span style="color: #000000;">,ASLine3,</span><span style="color: #ff0000;">' '</span><span style="color: #000000;">,ASLine4,</span><span style="color: #ff0000;">' '</span><span style="color: #000000;">,Asline5) </span><span style="color: #0000ff;">as</span><span style="color: #000000;"> [Display]<br></span><span style="color: #0000ff;">from</span><span style="color: #000000;"> Site<br></span><span style="color: #778899;">left</span><span style="color: #000000;"> </span><span style="color: #778899;">join</span><span style="color: #000000;"> area </span><span style="color: #0000ff;">on</span><span style="color: #000000;"> sarea</span><span style="color: #778899;">=</span><span style="color: #000000;">aarea<br></span><span style="color: #778899;">left</span><span style="color: #000000;"> </span><span style="color: #778899;">join</span><span style="color: #000000;"> tree </span><span style="color: #0000ff;">on</span><span style="color: #000000;"> treeid</span><span style="color: #778899;">=</span><span style="color: #000000;">atreeid<br></span><span style="color: #778899;">left</span><span style="color: #000000;"> </span><span style="color: #778899;">Join</span><span style="color: #000000;"> AddressStore </span><span style="color: #0000ff;">on</span><span style="color: #000000;"> AddressStore.assiteid </span><span style="color: #778899;">=</span><span style="color: #000000;"> ssitenum<br></span><span style="color: #0000ff;">where</span><span style="color: #000000;"> <br></span><span style="color: #c700c7;">isnull</span><span style="color: #000000;">(sisinactive,</span><span style="color: #098658;">0</span><span style="color: #000000;">)</span><span style="color: #778899;"><></span><span style="color: #098658;">1<br></span><span style="color: #778899;">and</span><span style="color: #000000;"> </span><span style="color: #c700c7;">isnull</span><span style="color: #000000;">(AIsInactive,</span><span style="color: #098658;">0</span><span style="color: #000000;">)</span><span style="color: #778899;"><></span><span style="color: #098658;">1<br></span><span style="color: #778899;">and</span><span style="color: #000000;"> </span><span style="color: #c700c7;">isnull</span><span style="color: #000000;">(ASInActive,</span><span style="color: #098658;">0</span><span style="color: #000000;">)</span><span style="color: #778899;"><></span><span style="color: #098658;">1<br></span><span style="color: #778899;">and</span><span style="color: #000000;"> sarea </span><span style="color: #778899;">=</span><span style="color: #000000;"> (</span><span style="color: #0000ff;">select</span><span style="color: #000000;"> aarea </span><span style="color: #0000ff;">from</span><span style="color: #000000;"> users </span><span style="color: #778899;">left</span><span style="color: #000000;"> </span><span style="color: #778899;">join</span><span style="color: #000000;"> site </span><span style="color: #0000ff;">on</span><span style="color: #000000;"> usite </span><span style="color: #778899;">=</span><span style="color: #000000;"> ssitenum </span><span style="color: #778899;">left</span><span style="color: #000000;"> </span><span style="color: #778899;">join</span><span style="color: #000000;"> area </span><span style="color: #0000ff;">on</span><span style="color: #000000;"> sarea </span><span style="color: #778899;">=</span><span style="color: #000000;"> aarea </span><span style="color: #0000ff;">where</span><span style="color: #000000;"> uid </span><span style="color: #778899;">=</span><span style="color: #000000;"> </span><span style="color: #098658;">$userid</span><span style="color: #000000;">)</span></div>
