Results 1 to 2 of 2
Thread: how to create an address field?
Dec 4, 2009, 12:52 #1
how to create an address field?
I want to create an address field in a table what would be the best configuration for that?
Dec 4, 2009, 15:33 #2
- Join Date
- Sep 2005
- Sydney, NSW, Australia
- 25 Post(s)
- 1 Thread(s)
It depends on how you intend using the address. Are you going to need to reference the parts of the address separately (eg. to find all the addresses in a given country)? If so then you need separate fields for each part of the address. Also if the same address is going to appear more than once or one entity needs to be able to have more than one address you will need to move the address into a separate table.