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 -- Homepage: https://www.familiegrosskopf.de/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