Re: [libreoffice-users] difficulty with base

Bonjour,
Thank you for your answer.
I'm gonna try this even if some details keeps a little obscure.
Perhaps, if you get time, could you modify the example base in the way 
you suggest ; I'll take a big look to it to see how you've done ?

cordialement,


Le 23/03/2021 à 20:35, Robert Großkopf a écrit :
> Hi Moebius,
>
> here the simple solution:
>
> Put away the table "codes".
> Edit table "Personnens"
> → add the field "Villes_ID" to "Personnes" (should be INTEGER;
> foreignkey from table "Villes")
> → delete the fields "Codepost" and "Ville" from this table. You will get
> this information from "Villes".
>
> You will search for "Villes" or "PostCode" later?
> Create a table filter for only one row.
> Fields are like  the fields in "Villes". The field "ID" could be boolean.
>
> Together with thgis table you could search for every "PostCode" or "Ville".
>
> Here a complicated solution:
> Rows of table "codes" will appear many times in "Villes".
> Rows of table "Villes" will also appear many times in "codes".
> You have to delete the "postalcode" für "Villes".
> You have to create a combination of the two elements together in table
> "Personnes".
> Change the fields "Codepost" and "Ville" from this table to INTEGER
> fileds. They will contain the foreignkey from the tables "Villes" and
> "code".
>
> I would prefer the simple method. You have to edit only one table to
> cretae the mostly used combinations of "Code" and "Ville". Then you
> could choose the values from this table in a listbox to put the
> foreignkey to "Personnes".
>
> Lets see whot you need for per private mail. Thins ist is too special
> for other people in this mailinglist.
>
> Regards
>
> Robert


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