This has always been a pain to do. I assume you mean a structure like a client w/ mutiple addresses and multiple phone numbers.
In this situation you could do something like this. Build a view between clients and addresses. Build your report off of that. Now build a lookup using the listof function to pull all of the phone numbers into a text variable. VariableName = (LISTOF(ColumnName)) IN LookUpTableView WHERE + KeyColumn = KeyColumn Take a look at the online help at http://www.rsyntax.com/Syntax.htm for the listof function. There are a few different ways to do this. Another method would be to use a temp table and stuff all of your data in there with 3 select statements and then run the report off of the temp table. Troy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Patrick Murphy Sent: Monday, July 14, 2003 10:01 AM To: RBASE-L Mailing List Subject: [RBASE-L] - One and Many Many Report I need to create a report where data will come from a main table and two additional tables that have a many-to-one relationship with the main table. This is easy to do with only one Many table involved, but with two (or more) I'm looking for an easier way to do it than doing a bunch of processing of the data. Is there a SQL command or View that can be established to make this easy? Patrick 6.5++ Windows 1.864xRT03 Example: Client Information Client's Children Client's Organizations
