MS Dynamics Technical / Functional Tips and Tricks

 this example to return the first only vendor name by the vendor account from all companies (CrossCompany) :  select firstonly crossCompany  _vendtable                    join  _dirpartytable                   where _vendtable.Party == _dirpartytable.RecId &&_vendtable.AccountNum==this.AccountNum ;