Database view to reference field

[ClaireB]

Hi, 

I'm trying to build a database view from one table (technical service table) to a reference field (PII data) on that table so I can see a many to many list view. 

This is the related list at the bottom of the first table


So I want to have a list view of each technical service with each corresponding PII Data name. 

Can anyone help with going about this. 



This is what I have so far. But I don't know what the where clause should be? This is my first time doing a database view. I can't find a common field on each of the tables to link in the where clause. Maybe I am doing something wrong. 

Thanks.

[ClaireB]

No, that was intentional, as that was the solution to my problem. I have already marked one of yours as helpful. I don't see the option to close the question.

[Ankur Bawiskar]

Just to check whether the where clause I shared in my 1st reply helped or not.

Regards
Ankur