Answer:
John wants that record
Step-by-step explanation:
Demonstrative pronouns are substitutes of nouns or noun phrases that point or indicate specific things, elements, people or animals that are near or far in distance or time. They can be singular or plural and there are only four: this, that, these and those.
In the sentence John wants that record, that is working as a demonstrative pronoun because it is used to indicate a singular element that is far in distance.