Related tables are not displaying from one side unless there is data to connect the two records?

[TOM Owles1]

Hi,

I wondered if anyone can help me figure out this strange behaviour.

I have a custom table ‘Control Sub Categories’ which is linked to another custom table ‘Threat Scenarios’.

The Control Sub Category table does not display the related Threat Scenarios unless data already connects the records. I am able to relate Control Sub Categories to Threat Scenarios from the Threat Scenario side, but not from the Control Sub Category side unless there is already existing data. I hope the following screenshots explain the situation.

No display of Threat Scenarios when on the Control Sub Category:

From the Threat Scenario side, I can see the link to Control Sub Categories:

If I relate the records, I can then see the Threat Scenario from the Control Sub Category:

But only as there is data to connect the two.

I believe that I should be able to see the Threat Scenario relation from the Control Sub Category without any data. Is there something I am missing?

Your input is much appreciated.

Thanks,

Tom

[AnubhavRitolia]

Hi Tom,

On Control Sub Category, go to the List Control of Threat scenarios related list. There may be some condition set. Check that 'Omit if empty' checkbox is not True/Ticked.

Please mark this as correct answer and helpful if it resolved, or mark this helpful if this help you to reach towards solution.

[Mahendra RC · Accepted solution]

Hello,

Go to Control Sub Category form, scroll down to the Threat scenarios related list. Right click on related list header and then click on configure --> List Control. You may see this Omit if empty checkbox is checked. if yes then please uncheck that if it is checked

Please mark my respsone as helpful/correct, if it answer your question.

Thanks

[Mahendra RC]

Hello @TOM Owles 

Just wanted to check with you, if the above response answered your question. If yes, then please do close this thread/question by marking the appropriate response as correct.

If you still need any further help or guidance on this then please update those on this question.

Thanks

[TOM Owles1]

Hi Anubhav and Mahendra, 

Thankyou very much for your response and detail. I can confirm this works!

Have a great day, 

Tom