Re: [libreoffice-users] How to change Writer form letter database connection

Spoke too soon. The data source changes but not the fields. Unless I 
change the fields in the document (re-insert them from the current data 
source), they show up as blank. This is NOT what I want. I want the 
fields to move to the new data source.

In fact, I can't think of a reason for the current behaviour. Why should 
switching data sources do that instead of the more sensible behaviour of 
picking up the data from fields with the same name in the new data source?


On 11/10/16 01:34 PM, Gary Dale wrote:
> No. I think you're thinking about Ctrl-Shft-F4 which brings up the the 
> Data Sources toolbar.
>
> Actually, it's started working now for some reason. The error message 
> I was getting has gone away. Weird.
>
>
> On 11/10/16 12:22 PM, Tom Davies wrote:
> > Hi :)
> > Is it F4 to bring up a "connected databases" toolbar?
> > Regards from
> > Tom :)
> >
> > On 11 October 2016 at 17:00, Gary Dale <garydale@torfree.net> wrote:
> >
> > > How does one go about changing the database that a form letter 
> > > connects to?
> > >
> > > I have this problem in several "form letters". I want to connect to a
> > > different database than the one they were created against for the 
> > > simple
> > > reason that I have a different set of data that I want to print 
> > > against.
> > >
> > > If this is a simple spreadsheet connection then I can simply connect 
> > > the
> > > database to a different spreadsheet. However I have a some cases 
> > > where I
> > > need to use queries with joins and/or sub-queries, which precludes 
> > > the use
> > > of a spreadsheet connection.
> > >
> > > While the obvious answer is to use a single database and use a query to
> > > only select the current data, this is not ideal in my case. I prefer to
> > > keep the data sets entirely separate so I can archive them by event 
> > > along
> > > with a lot of other event-specific files.
> > >
> > >
> > > --
> > > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> > > ubscribe/
> > > 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


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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