Re: 2 Base tables in a FORM, a JOIN and ORDER BY Question!
From: DanHW <danhw_at_aol.com>
Date: 27 Nov 1998 15:20:16 GMT
Message-ID: <19981127102016.10832.00001378_at_ng-ca1.aol.com>
Date: 27 Nov 1998 15:20:16 GMT
Message-ID: <19981127102016.10832.00001378_at_ng-ca1.aol.com>
>I have 2 Base tables in a form. Lets say A & B.
>
>I have linked the 2 tables via their keys.
>
>I am displaying the main information on the form, from table A.
>
>BUT, I want to ORDER the TABLE A details by a field in TABLE B.
>
>HOW DO, I DO IT ???
>
>HELP
>
How do you get 2 base tables in a form?
If you have a VIEW that joins the table, just include the definition of the column in the view. In the ORDER BY for the block, put "ORDER BY your column". You do not have to include it on any of the block.
Dan Hekimian-Williams Received on Fri Nov 27 1998 - 16:20:16 CET