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.
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
