Date: prev next · Thread: first prev next last
2016 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.