Set relationship query

omsa1
Kilo Guru

Hi There,

I need help with this. I created a new table called problem2 and a related list relationship called "linked tickets". i've added new button for related problem link so that users can add record into problem2 table using this button . When i add query , from table problem2 to table problem   and added query current.addquery('problem'.sys_id); its showing all the records in that Problem 2 table , not the one created under particular problem ticket. how can i filter only problem2 table record that was created under that particular problem ticket. for example problem ticket should have only one problem2 table record. but its showing all the records under problem2 table. Please help.

find_real_file.png

1 ACCEPTED SOLUTION

Hi Chuck,



Thank you that was is the one causing the issue. I created problem reference field in problem2 table and then it gave me problem2-->problem....i added that to related list and renamed the label to Linked Tickets..its working as expected..Thanks for your help and input appreciate it.


View solution in original post

7 REPLIES 7

If problem is a reference field to the problem table, and the goal is to place the related list of linked tickets on the problem form, then you should already have a related list automatically available for Linked Tickets -> Problem.



You shouldn't need to create a relationship definition. Reference fields automatically make a related list available. Have you looked under Configure> Related lists for an entry like that?


Hi Chuck,



Thank you that was is the one causing the issue. I created problem reference field in problem2 table and then it gave me problem2-->problem....i added that to related list and renamed the label to Linked Tickets..its working as expected..Thanks for your help and input appreciate it.


You are very welcome. Don't forget to remove your relationship definition to avoid confusion in the future.



If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.



If you are viewing this from the community inbox you will not see the correct answer button.   If so, please review How to Mark Answers Correct From Inbox View.



Thank you