AppGini Community Forums

Good morning to all appgini community,
I have created 3 tables (alarm_list, document & alarm_doc).
alarm_list table is to store all the alarms information.
document table is to store all the documents.
alarm_doc table is to store the link between alarm and the documents related to it.
I have also created an auto-fill lookup field in the alarm_doc table hoping that I can click to view the document.
However, what I see in the child table view is only the filename.

How can I make it a clickable link or icon instead of just a filename.

Thank you and have a nice day. and stay safe.

Hi Zala,

I have done this without a specific correlation table. The document table is a child of my primary table, so there is a reference to the primary ID in each record of my document table. Perhaps the real issue though is the configuration of your File column. My document (column) is configured as a File Upload on the Media tab, I think that is what makes it a clickable link.

~Paul

Hi Paul,
Thanks for the explanation. I understand that if I make the document table as the child, it will make life easy.
However, if most of the parent items are having the same document as their child, it will consume storage space and updating the documents will be an endless process. That is why I have decided to have a correlation table.
Hope to find a good solution soon.
Thanks again Paul.