I'm not a programmer, so I'm betting there is an easy solution for this.
I have a table similar to the following:
ID Name RelatedID RelatedName
1 A 1 <TBD>
2 B 3 .
3 C 3 .
The relatedID field provides an alternate name (RelatedName) for a customer. I need to populate the RelatedName field by querying ID and pulling the name field. My results should look similar to this,
ID Name RelatedID RelatedName
1 A 1 A
2 B 3 C
3 C 3 C
I can handle the RelatedName fields for IDs 1 and 3. How do I handle it for ID 2? Make sense?
Thanks in advance.
-If it ain't broke, break it and make it better.
I have a table similar to the following:
ID Name RelatedID RelatedName
1 A 1 <TBD>
2 B 3 .
3 C 3 .
The relatedID field provides an alternate name (RelatedName) for a customer. I need to populate the RelatedName field by querying ID and pulling the name field. My results should look similar to this,
ID Name RelatedID RelatedName
1 A 1 A
2 B 3 C
3 C 3 C
I can handle the RelatedName fields for IDs 1 and 3. How do I handle it for ID 2? Make sense?
Thanks in advance.
-If it ain't broke, break it and make it better.