Re: Order by non-base table fields
From: David Field <davidf_at_rockdb.demon.co.uk>
Date: Wed, 24 Jun 1998 12:23:40 +0100
Message-ID: <898687308.11410.0.nnrp-03.9e981d27_at_news.demon.co.uk>
Date: Wed, 24 Jun 1998 12:23:40 +0100
Message-ID: <898687308.11410.0.nnrp-03.9e981d27_at_news.demon.co.uk>
Try creating a view which has the two tables joined and therefore brings in the description column. You can then use the ORDER BY property of the base table block. The only disadvantage is that you have to intercept and write code to handle any INSERTS or UPDATES. Received on Wed Jun 24 1998 - 13:23:40 CEST