Are you bringing over a 'parent' list into a child record or are you looking to embed a report of related 'child' records in a parent record?
Yes, because CPM Name is probably the proxy field for that parent table. As parent, it will display all it's choices. You may want to create a formula text field that captures the name of CPM Name. Something like this.
[Formula Text field]
[CPM Name] << content of the formula text field, just [CPM Name], that's all.
Not a problem at all. I'm still a beginner relatively speaking. I have not forgotten what that is like. Okay, so ...
Make a formula text field called "CPM Name Text"
in the properties for the field where you enter code, simply put in:
That's it. Save the field and see your results.
I made an assumption that you have related the two tables. Have you done that? Or do you not want to make them related? I recommend you do.