Hi, I'm new with Libre Office base and there is my actual problem...
(excuse my english, I speak french) I have a base with a lot of tables. Tables for Prefix, first name (prenoms) and Family names (Noms) In another table, I have PERSONS table: build from the 3 previous table. So on the Form, I see names, first name etc. but in the table only numbers are presents. I don't know if it is clear.... The problem is in Propriety list zone on the data tab, for list content, on the form, to concatenate PREFIX FIRSTNAME FAMILY NAME, I have this: SELECT "PREFIX"."Prefix" || ' ' || "PRENOMS"."Prenom" || ' ' || "NOMS"."Nom", "PERS"."Idpp" FROM "PERS" LEFT JOIN "PREFIX" ON "PREFIX"."Cprefix" = "PERS"."PREFIXC" LEFT JOIN "PRENOMS" ON "PRENOMS"."Cpr" = "PERS"."PRENOMC" LEFT JOIN "NOMS" ON "NOMS"."Idnom" = "PERS"."NOMC" ORDER BY "NOMS"."Nom" It's work but each time I quit this base and reopen it, Base keep only the first line of this sql things... Any help would be appreciate. Thx Denis -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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
