Boy is my face red :-) I guess that's my leason for the day. Still have lots to learn
On 19 Jun 2003 at 11:52, Albert Berry wrote: > 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 > > Victor Timmons Tiz's Door Sales, Inc 425-258-2391
