Thread Rating:
  • 1 Vote(s) - 1 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Last address field could be country...
09-10-2012, 04:36 PM, (This post was last modified: 09-10-2012, 04:36 PM by PakRicard.)
Last address field could be country...
Hi all:

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.

Does it make sense to the developer team?

Attached Files
.txt   countries.txt (Size: 9.92 KB / Downloads: 2)
Pak Ricard

Messages In This Thread
Last address field could be country... - by PakRicard - 09-10-2012, 04:36 PM

Forum Jump:

Users browsing this thread: 1 Guest(s)