Unfortunately, a view that has more than one table in it is not editable. One could use such a view for a form used to only view the data, but not for editing.
"Victor Timmons" <[EMAIL PROTECTED]> wrote: >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 > > -- 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
