I do not typically use indexes on temp tables because they run so fast and are usually a subset of the original table but if I do, I only use indexes not foreign keys. Dan Goldberg
_____ From: [email protected] [mailto:[email protected]] On Behalf Of Roberts, Jennifer Sent: Wednesday, April 01, 2009 6:02 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Sub-Reports Question Hi Dan, I've tried to create a temp table and link one of the columns to my main table. I am using the following code: ALTER TABLE `TSUBEA` ADD FOREIGN KEY + (`CaseManager` ) REFERENCES `Security` I am receiving an error message that the referenced table doesn't exist. Do you have to do something special when trying to add a foreign key to a temp table? Thank you, Jennifer From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Tuesday, March 31, 2009 2:58 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Sub-Reports Question I just did a report with a dummy master table and six tables as sub-reports. None of the columns had a relationship to each other. I had to have a linking table between the master table and the slave tables. Since I was creating temp tables, I just used a bogus column in all the tables and put a value in it to link them. Without the linking column it does not work. When I created the temp table I made sure that no table had a linking column to each other or the master except the bogus column. Dan Goldberg _____ From: [email protected] [mailto:[email protected]] On Behalf Of Roberts, Jennifer Sent: Tuesday, March 31, 2009 10:33 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Sub-Reports Question Hello, I would like to display a report with four slave tables and four sub-reports. My slave tables are actually temporary views that are created before the report generates. I am only able to get one sub-report to display. I am using the child option, and I have them shifting relative to the report in front of it. Currently all the reports are in the detail band of my main report. I have tried moving them each to a band of their own and then making them section reports and that didn't work either. Is there some sort of settings - like with the forms - where you can set your table settings, such as one to one or one to many? For a report, does the slave tables have to have a column in common with the main table for items to display? Thank you for any help. Jennifer Roberts Business Applications Specialist Ohio Masonic Home This electronic message contains information from The Ohio Masonic Home, its operating subsidiaries or affiliates. The information may be confidential, privileged or otherwise protected from disclosure. The information is intended to be received solely by [email protected], for use as designated in the message. If you are not the designated recipient, you are instructed not to review, disclose, copy, distribute or otherwise use of this transmission or its contents. If you have received this transmission in error, please notify The Ohio Masonic Home immediately at [email protected]; in addition, please delete your record of transmission. Sending, receiving, downloading, displaying, printing material that is harassing, fraudulent, offensive, intimidating, defamatory, or otherwise unlawful or inappropriate is strictly prohibited by The Ohio Masonic Home. This electronic message contains information from The Ohio Masonic Home, its operating subsidiaries or affiliates. The information may be confidential, privileged or otherwise protected from disclosure. The information is intended to be received solely by [email protected], for use as designated in the message. If you are not the designated recipient, you are instructed not to review, disclose, copy, distribute or otherwise use of this transmission or its contents. If you have received this transmission in error, please notify The Ohio Masonic Home immediately at [email protected]; in addition, please delete your record of transmission. Sending, receiving, downloading, displaying, printing material that is harassing, fraudulent, offensive, intimidating, defamatory, or otherwise unlawful or inappropriate is strictly prohibited by The Ohio Masonic Home.
