<div>
mnasman : &nbsp;I know both the methods you described, i am just curious if u could do sorting with lookup field (kind=fkLookup) instead. &nbsp;<br />
<br />
Thanks. <br />

</div>


mnasman :  I know both the methods you described, i am just curious if u could do sorting with lookup field (kind=fkLookup) instead.  

Thanks.


<div>
only with a query by including the field, which is referenced like<br />
<br />
select a.*, b.lookupresultfield from tableA a, tableB b where a.lookupidfield = b.idfield order by b.lookupresultfield <br />
<br />
in some databases b.fields must not be included into the fieldlist after the select in some other databases is this a must<br />
<br />
meikl ;-)
</div>


only with a query by including the field, which is referenced like

select a.*, b.lookupresultfield from tableA a, tableB b where a.lookupidfield = b.idfield order by b.lookupresultfield

in some databases b.fields must not be included into the fieldlist after the select in some other databases is this a must

meikl ;-)

<div>
Thanks for the feedbacks.... &nbsp;
</div>


<div>
Upon review of the comments here, I am recommending this disposition:<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; points to mnasman<br />
<br />
Please post a comment if you disagree.<br />
<br />
DanRollins -- EE database cleanup volunteer
</div>


Upon review of the comments here, I am recommending this disposition:

        points to mnasman

Please post a comment if you disagree.

DanRollins -- EE database cleanup volunteer

<div>
per recommendation.<br />
<br />
SpideyMod<br />
Community Support Moderator @Experts Exchange
</div>


per recommendation.

SpideyMod
Community Support Moderator @Experts Exchange

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Is there anyway to sort rows in grid using column that is based on lookup field?<br />
<br />
The grid contains one lookup field that is pointing to the master file record ( i.e. EmployeeName ), I need to sort the rows based on the Employee's Name. &nbsp;How?<br />
<br />
Thanks
</div>
</div>


Hi,

Is there anyway to sort rows in grid using column that is based on lookup field?

The grid contains one lookup field that is pointing to the master file record ( i.e. EmployeeName ), I need to sort the rows based on the Employee's Name.  How?

Thanks

how to sort rows in grid using lookup field column?

Delphi is the most powerful Object Pascal IDE and component library for cross-platform Native App Development with flexible Cloud services and broad IoT connectivity. It provides powerful VCL controls for Windows 10 and enables FMX development for Windows, Mac and Mobile. Delphi is your choice for ultrafast Enterprise Strong Development™. Look for increased memory for large projects, extended multi-monitor support, improved Object Inspector and much more. Delphi is 5x faster for development and deployment across multiple desktop, mobile, cloud and database platforms including 32-bit and 64-bit Windows 10.