When you set up a lookup column, you can choose between tables and relations. Be sure to choose the relation. It sounds like you already have a lookup column, but you just need to make a small change to it to use the relation instead of a table.
1 Like