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