In the new related list tab the record created for one demand showing same record in all demands.

Mansi roy · ‎10-03-2024

Hello ALl,

I have created one new related list tab.I have added to demand related list.

For this i have created one new table and created the columns as required.

When i am creating any new record from this related tab it is showing in all records. But it should visible only for that record.

the Below one is relationship.

the record created for one demand is showing in all demand records.

Can anyone please help me why this is happening.

Regards,

Mansi

Animesh Das2 · ‎10-03-2024

Hi @Mansi roy ,

Firstly, you must have a reference field on Efforts table referencing Demand table record. Then in the relationship record that you created, please put this below line of code in the 'Query with' field,

current.addQuery('sys_id', parent.<reference field name from 'u_efforts' table>);

replace this <reference field name from 'u_efforts' table> with actual field name from 'u_efforts' table in the line of code mentioned above.

Since there is no condition you put in the 'Query with' field, the relationship was messed up.

If this address your question, please mark this response correct by clicking on Accept as Solution and/or Kudos.

You may mark this helpful as well if it helps you.

Thanks,

Animesh Das

View solution in original post

Animesh Das2 · ‎10-03-2024

Can you please share SS of the relationship record? Please ensure the field name is correct you are using. Also a SS of the reference field(Number) that is created on Efforts table by clicking 'show Number' after right click on Number field.

Mansi roy · ‎10-03-2024

Hi @Animesh Das2,

Animesh Das2 · ‎10-03-2024

the ref field looks good. For at least one Efforts record you already have one demand selected in that 'u_number' reference field right?

Can you please also share the relationship record SS just to have a look?

Mansi roy · ‎10-03-2024

Hi @Animesh Das2 ,

In the number field the demand number is not coming.It is coming as blank.As per my understanding in the number the demand number for which i am creating efoorts should be autopopulate.Right.How to do that.

Animesh Das2 · ‎10-03-2024

Can you please share the SS of the reference specification tab of 'u_number' field dictionary entry? If it is referencing correct Demand table then you should be able to select any demand record in that u_number field.