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.

[Ankur Bawiskar]

Hi,

update your where clause for u_pii_data table as this

pii_source_system = techser_sys_id

Ensure you add Source System field as View Field for PII Data table

Regards
Ankur

[ClaireB]

Hi @Ankur Bawiskar 
Thanks for the reply. 

I have added the where clause as you advised. 

I don't have Source System as a field for the PII Data table:

[Ankur Bawiskar]

Hi,

which field on PII Data holds the reference to technical service table?

You need to use that here

pii_source_system = techser_sys_id

Regards
Ankur

[ClaireB]

Hi,

Here is a record on the PII Data table.

The Source System is the Technical Service name. 




But when I try the clause, I get: