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,

Can you explain this

1) which field on PII Data table is reference to Technical Service?

OR

2) which field on Technical service table is reference to PII data?

Regards
Ankur

[ClaireB]

So on the Technical Service table, the PII data records show in a related list at the bottom of the record:


And on a PII Data record, there is a list of the related Technical services at the bottom of that record:



Not sure if this answers what you ask

[ClaireB · Accepted solution]

I've just realised I might have been looking in the wrong place, and instead created a custom m2m table for what I needed. 

Thanks Ankur anyway for your help!

[Ankur Bawiskar]

@ClaireB 

Glad to know.

If my response helped please mark it correct and helpful and close the question.

Regards
Ankur

[Ankur Bawiskar]

@ClaireB 

Did you accidentally marked your own response as correct.

If my response helped please mark it correct and helpful and close the question.

Regards
Ankur