Re: [libreoffice-users] Concatenating fields in related form

Hi Adam,

> I have a Client form with ClientID, FirstName and LastName fields and
> a Project form with ClientID and FullName fields. In Filemaker I was
> able to type in a client id into the Project form and it would insert
> the first name and last name from the Client form into the FullName
> field of the Project form. How can I do this in Base?

In databases values shouldn't be duplicated. So "FirstName" and
"LastName" from one table shouldn't be "FullName" in the same or another
table. You will get this values through the primary key and a query. I
you want to show "Name" in one field you have to concatenate it like
SELECT "FirstName"||' '||"Lastname" FROM "Table"
If you will see this directly while input of values you have to set the
input of "ClientID" in the mainform and the query for the shown content
in the subform. "ClientID" will be the field connecting to the subform.
It could be set up as a listfield with the code
SELECT "FirstName"||' '||"Lastname", "ClientID" FROM "Table"
So it will show the "FullName" if the clientID is submitted from the
mainform.

But: Do you really know all ClientIDs? I would prefer a listfield
instead, which directly shows the names.

Regards

Robert
-- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy