Can not you% construct a table that contains one result of another table in one of its columns?
The master key would be the reference.