AnsweredAssumed Answered

how to handle the addresses best?

Question asked by grabo on Oct 20, 2017
Latest reply on Oct 24, 2017 by grabo


In one address I have more values: city, street, civic number, postal code, province, common code. Many data. In a masterpiece how best to handle them? Some recommend putting all the caps in a separate table with id_cap, all the ways, and all the cities ... so many separate tables joined at a later time. It would be nice that by entering an address I would suggest possible combinations or inserting the city to automatically populate the possible fields. Certainly a way can be common to more cities ... so how do you suggest tackling the issue?