I needed something much more simple and was reading/experimenting establishing same table relationships without success (may be my records were not unique but did not have the time to troubleshoot root cause) for at least the last couple of hours.
What I wanted to achieve is to have a copy of the same field for the purpose of another report (did not want to rename the original field) only named differently, so I was trying a to build lookup and snapshot field(s) instead of what worked like a charm - a formula field referencing the parent field.
Posting it just in case others might be searching for something that simple.
