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

Thank you for taking the time to reply Robert.

> 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.

I can only get this to work (with a list box) if there is only one project for each client.
If I have two separate project records with the same client id I get an error.

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

I have nearly 1000 clients. It would be tedious scrolling through those looking for a client, or am 
I missing something?
I was hoping I could recreate my old Filemaker method of linking the records.

Thanks,
Adam
-- 
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