That's exactly what I wanted and couldn't find anywhere! I'm very grateful John
On 17 October 2012 21:14, Girvin R. Herr <[email protected]> wrote: > > > John Clegg wrote: > >> I have a base file attached to a MySQL database on a remote server. I have >> a form that I use to view and edit the data in one table. >> >> Others also access the database, and I need to experiment with the data in >> that table without molesting the master copy. >> >> One solution would be to make a complete copy of the database, but as I >> want to make copies of the main table many times a day that would be a >> laborious solution >> >> It is easy to make a duplicate of the main table within the database, and >> also easy to make a copy of the form in the base file, but what I need to >> do now is point the copy of the form at the copy of the table. >> >> I thought it might be possible to open the odb file as a zip file and find >> the form data containing the table name somewhere in it, and edit it to >> the >> copy table name, but I haven't succeeded yet. >> >> Does anybody know if this is possible - or even if there is a much easier >> way? >> >> >> > John, > I am assuming you need to change the table that your form points to. You > can do this by: > > 1. Bring up your form in edit mode (right click on form name and > select "Edit".) > 2. Select the "Form Properties" window (this is the icon that looks > like a window with 2 buttons with an arrow pointing to it, and > with a help balloon that says "Form". > 3. In the popup window, select the "Data" tab. > 4. Change the "Content" box to the table you want to use from the list. > > If the new table's column (control) names are different, you will have to > change those too in the form editor. You do that by Ctrl-left-clicking on > the form's control box and selecting its "Data" tab and selecting the new > name from the list derived from your new table. Do that for each control > that has a different name from your old table. > Hope this helps. > Girvin Herr > > > -- > For unsubscribe instructions e-mail to: [email protected].** > org <users%[email protected]> > Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** > unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> > Posting guidelines + more: http://wiki.**documentfoundation.org/** > Netiquette <http://wiki.documentfoundation.org/Netiquette> > List archive: > http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/> > All messages sent to this list will be publicly archived and cannot be > deleted > > -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
