I dont know what "OP" in first paragraph stands for -- please explain
Original Poster (person who started the thread)
When you use the term name alias am I correct in assuming that that would be the same thing as I am
calling "custref" ??
I'm advocating keeping the original valid name in its own field. Then break it into additional fields as you see fit. I would consider (in addition to any other fields that come before and after) as an example:
Salutation
|
Fname
|
Lname
|
Alias
|
Mr. |
Ian |
O'Hara |
Ohara |
You may never encounter the issue that arises when trying to build query sql in code and the names have apostrophes, but the potential is there. If you send email, you'd use the LName field in the To, not the alias as Mr. O'Hara might object to OHara. The alias might be going a bit beyond what you need/want. As a minimum, have the 1st 3 columns, but not Mr Ian OHara all in one field.
(the use of "so" is just a South African corruption of a phrase like " to further elaborate" - excuse the local slang)
That's just a social commentary in my signature. It appears in every post unless I remove it, which I usually do after the first post I make. It may not be obvious, but it is also a commentary on "Like" for which I don't seem to have the words to truly express how much that one bugs the crap out of me. I will have to come up with one for "Uh and Umm" as they're getting far too prevalent on TV. If you were here a couple of months ago, you would have seen "Irregardless, ain't no such word as reoccur". I was called out for one other error for that one, yet there were at least 2 others, all deliberate. I will address your other questions in a separate post as soon as I get a chance. Back to my chores for the moment.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.