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

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

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


LibreOffice Community:

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


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.