Last address field on debtormaster or suppliers is usually used for Country. I can't imagine use the latest field of an address for continent or planet or something larger than country (at least on this century).
So, could we have a table of countries and fill this field from the countries table?
It will avoid the problem of manual entry of the same info in different ways. Ex.: US, U.S., U.S.A. United States, etc all OK, all possible and all living in my DB to refer to one country. If we had this info in a table all the records would have the same entry, so we could filter by country easily.
I have a table of countries (found somewhere on the www) already populated (attached) we could use as a base.
Last address field could be country...
