For the secondary table you use the arrange by clause. Se help manual for edit using and/or print
Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För cfgrimes Skickat: den 6 juli 2009 13:08 Till: RBASE-L Mailing List Ämne: [RBASE-L] - RE: Need Help Report Thanks for your suggestion, Jim. I've only created a View once a very long time ago in old RBase 4.5 - remember having lots of problems afterwards. Could easily have been my fault, but is there any chance there is a way to do this using existing table, report form? If not, would I be able to keep original report and point to the View instead, or would I need to recreate from scratch? Cathy ----- Original Message ----- From: Jim Belisle <mailto:[email protected]> To: RBASE-L Mailing List <mailto:[email protected]> Sent: Monday, July 06, 2009 3:56 AM Subject: [RBASE-L] - RE: Need Help Report Cathy, One way is to create a view that includes both tables. That way you have access to all the columns in both tables for either sorting or limiting the information you bring up in the report. The common column will be the linking column. Jim _____ From: [email protected] [mailto:[email protected]] On Behalf Of cfgrimes Sent: Monday, July 06, 2009 5:51 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Need Help Report Sorry for the simple question. I've been happy with all my reports, tables, forms, etc., so it has been many years since I actually designed one....and have forgotton a whole lot. I have a main table with data entries. Have second Category table with 3 columns. One of the Category columns is also included in main data table, so can easily sort by that. Now, however, I would like to sort a report based on a Second Column in Category table without having to add that column to my main data table. Can't for the life of me remember how to do this - or even if I can. Is there some easy way? I have 7.6. Cathy Huntington Beach, Calif
