create a view bringing your data together and base your form off of that. easy
On 18 Jun 2003 at 14:22, Gary L. Winzeler wrote: > With the Company table as the master table you then only see one company at a > time. > > Which only provides for the region to see one companies sales at a time, vs > what I would like - all the sales for the month ordered by company name. > > GARY > > > At 04:32 PM 6/18/2003 -0400, you wrote: > > 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
