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
But: Do you really know all ClientIDs? I would prefer a listfield
instead, which directly shows the names.
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Impressum (Legal Info)
: 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