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
