Related list for multiple pos

[Poorva Bhawsar]

Hi Community,

I want to create a custom related list where i have 2 tables involved. One table has the user id and po number in it and another table has the po id which is a reference to po number of first table.

I want to show the records of multiple po ids per user in the main table. Main table contains all these fields in it.

What is the logic to show multiple po ids per user?

Thanks

[Runjay Patel]

Okay, then share the screenshot of your related list configuration. Also share the field mapping present on both form.

[Poorva Bhawsar]

Here is the screenshot of the related list.

Table 1 Screenshot which contains user id, user name and po number fields in it.

Table 2 screenshot which contains po id as a reference field in it and its taking reference from the first table PO number field.

Now, i want if xyz user from first table have multiple po ids 1,2,3 and 4 then it should show these records under the related list.

[Poorva Bhawsar]

@Runjay Patel  your help is appreciated here. 

[Runjay Patel]

Hi @Poorva Bhawsar ,

Can you share the screen short of form where these all fields are available.

Is PO ID on from 1st table have reference to po table or it is string filed and user puts comma separated po ids.

[Poorva Bhawsar]

PO ID is a reference field referring to EPP table from po number field. No, i am not passing any comma separated values there.