That worked fine; thanks for the tutorial. One thing I noticed is that in the Form Designer window, just below the form action .choices is some text that is a bit confusing:
"Form Table lblReport Form Description lbldescription" is that just some left over text, or does it mean something, or what? seems to be static text... On Sat, Mar 26, 2011 at 1:53 PM, A. Razzak Memon <[email protected]> wrote: > At 01:49 PM 3/26/2011, William Stacy wrote: > > Actually I want to drop the main table off this form. >> Rbase seems to not want to do that. >> > > Bill, > > You cannot simply DROP the Master Table that is associated with a table > dependent form, regardless of what Slave Table(s) are being tagged along > in the same form. > > In your specific situation, to switch form tables, follow the steps below: > > A Simple Example and Exercise: > > -- Current Situation > Form Name: MyFirtForm > Main Table: TableOne > Slave Table: TableTwo > > -- Ultimate Goal/Objective > Form Name: MyFirtForm > Main Table: TableTwo > Slave Table: TableOne > > Here's how: > > 01. Using the Database Explorer | Forms > > Right click on the MyFirtForm form and select "Rename Form..." > > In the Rename Form Dialog Box, use the Form Name as: MyFirtForm_BKP > and click on [OK] button. > > Notice that the form "MyFirtForm" is being renamed to "MyFirtForm_BKP" > with the same Main Table as "TableOne". > > 02. Now highlight the same form MyFirtForm_BKP, right-click, and select > "Copy Form ..." > > In the Copy Form Dialog Box, use the Form Name as: MyFirtForm and > Select "TableTwo" from the drop-down list of Table/View Name. > > At this stage you may want to update Form Comment, if you wish. > > Click on [OK] button. > > Notice that the form "MyFirtForm" is now being associated with a > different Main Table as "TableTwo". > > 03. Finally, open this "MyFirtForm" form in form designer to associate > the Slave Table as "TableOne". > > Form Designer | Main Menu | Tables | Add or Remove Tables > > Notice the Main Table Name as "TableTwo" and Slave Table as > "TableTwo" as well. > > Highlight the "TableTwo" table in the list of Slave Tables and then > double-click on "TableTwo" or simply click on [Remove] button to > remove this table. > > Now select "TableOne" from the list of Tables/Views and then > double-click on "TableOne" or simply click on [Add] button to > add this table as Slave Table. > > Click on [OK] button to save these changes. > > 04. Housekeeping > > Once everything is taken care of, you may delete the "MyFirtForm_BKP" > form that was temporarily copied in Step 01 above. > > That's all there is to it! > > Have fun and take good note of this technique, if and when necessary. > > Very Best R:egards, > > Razzak. > > > -- William Stacy, O.D. Please visit my website by clicking on : http://www.folsomeye.net
