[libreoffice-users] Re: Combining Fields in Base.

Le 30/06/11 15:54, Ian Whitfield a écrit :

Hi Ian,

> I want to 'link' to the photos, (2 for each record), in place of the
> default embedding to help reduce the size of the DB and for this I need
> a path to be specified in each record for each photo. In place of typing
> in the full path every time I would like to have a fixed "Path to Photo
> Folder" field and just put the "Photo's File Name" under each photo. No
> problem with this.
>
> BUT the next step has me fooled!! I created another field called"Full
> Path To Photo" and need this field to automatically concatenate the
> first two values ie "Path to Photo Folder" + "Photo's File Name".
>
> Is this possible and how can I do this?

AFAIK, this is not possible via the Table definition UI. What might be
possible is the use of a combo box on a Form, where the combo box would
combine the data from the string corresponding to the path and the data
corresponding to the image file name and then presenting the combined
value to the user. I do not think, however, that it is possible to
present the user with a clickable link in that case, other than by
writing a macro that would do that for you e.g. via a button.

Alternatively, you could always try a form based on a query, where the
query would concatenate the two fields and present the combined value to
the user.

You might want to look at Roberto Benitez's book on Programming OOo Base
using OOoBasic. Also look at Andrew Pitonyak's guide (the name of which
I've forgotten for the moment).


Alex


-- 
Unsubscribe instructions: E-mail to users+help@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