Need help on whether to use IF or Case
I have a list of locations that i am trying to make a formula derived from a current field. but naturally i have about 100 locations that then have corresponding regions , so i would have 3 statemen...
Forum Discussion
I'd probably create a Locations table, yeah. And then whatever table has Location in it, look up the related Region from the Locations table onto that table. Much easier to manage.