That's a shame because it does present the data in the order (I think) you want just running a non-region form.
Regards, Alastair. ----- Original Message ----- From: "GARY Winzeler" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, June 19, 2003 8:24 PM Subject: [RBASE-L] - Re: Edit using - Razzak's Reply > No - I tried that and it goes by the order of the rows in the table that > the form is driven by not the view in the sub-select. > > At 06:40 PM 6/19/2003 +0100, you wrote: > >Gary, > > > >Can you do something like this: > > > >1) Create a (temp) view based on both tables that contains _only_ the rows > >from the sales table that you want to edit and _ordered_ in the sequence > >that you want it, then... > > > >2) edit using your original single table form with this sort of command: > >edit using salesform where cid in (select cid from [viewname]) > >Do _not_ order the edit command! > > > >If I'm not mistaken R:Base will take the data in the order it appears in the > >view rather than the original table - but I haven't tested this specifically > >with a region in a form. > > > >Regards, > >Alastair. > > > > > >----- Original Message ----- > > > > > >> > > > >> At 12:40 PM 6/18/2003 -0700, Gary Winzeler wrote: > > > >> > > > >> Using Windows 6.5++ Ver 1.866xRT03 Is there any way to order rows > > > >> in a single table form with a region based on a column in another > >table. > > > >> > > > >> Here is what I have: > > > >> > > > >> Company table > > > >> cid integer - Unique id > > > >> cname (company name text 30) > > > >> ... > > > >> > > > >> Sales table > > > >> cid integer > > > >> ... > > > >> > > > >> I need to edit data in the sales table only - > > > >> Edit form is single table based on the sales table and I would like to > > > >> order by cname, I would rather not add the column to the sales table. > > > >> > > > >> > > > >> Gary, > > > >> > > > >> Yes, you CAN! > > > >> > > > >> 01. Copy that form and use the Company as Master Table. > > > >> > > > >> 02. In Form Designer, Add Sales table as Slave table and then > > > >> set Sales as your current table. > > > >> > > > >> Create a region with everything based on Sales table. > > > >> > > > >> Note: You don't need to locate any field or anything related to > > > >> Company table, etc. on that form. > > > >> > > > >> 03. EDIT USING SalesData + > > > >> ARRANGE Sales BY OrderDate ASC + > > > >> ORDER BY CName > > > >> > > > >> That will give the results you need. > > > >> > > > >> All records will be sorted by CName (table=Company) > > > >> along with the OrderDate (table=Sales). > > > >> > > > >> or simply: > > > >> > > > >> EDIT USING SalesData ORDER BY CName > > > >> > > > >> Hope that helps! > > > >> > > > >> Very Best R:egards, > > > >> > > > >> Razzak. > > > >> > > > >> > > > >> Gary L. Winzeler > > > >> > > > >> DAQtech, Inc. > > > >> Data Acquisition Technology > > > >> and Sensor Instrumentation > > > >> <mailto:[EMAIL PROTECTED]> > > > >> <http://www.daqtech.com/> > > > >> > > > >> Office 408-847-4800 > > > >> Fax408-847-4097 > > > >> Cellular408-483-7739 > > > > > > > > > > > > > > > >Victor Timmons > > > >Tiz's Door Sales, Inc > > > >425-258-2391 > > > > > > > > > > > > > > > > > -- > > > Albert Berry > > > Full Time Consultant to > > > PSD Solutions > > > 350 West Hubbard, Suite 210 > > > Chicago, IL 60610 > > > 312-828-9253 Ext. 32 > > > > > > > > > __________________________________________________________________ > > > McAfee VirusScan Online from the Netscape Network. > > > Comprehensive protection for your entire computer. Get your free trial > >today! > > > http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 > > > > > > Get AOL Instant Messenger 5.1 free of charge. Download Now! > > > http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 > > > > > > > > > > > > > >Victor Timmons > >Tiz's Door Sales, Inc > >425-258-2391 >
