display attachment link on grid

Scriptcase 9 General
#1

Hi,

I have a table named table1 and I created a form for it. In the form, I created a new field called “attachment”.
For this new field, I have the following settings:

  1. Data Type = Document (File Name)
  2. Multi-upload
    Table = document_upload
    a) id = Auto increment
    b) foreign_id = Foreign Key
    c) filename = upload

Once I run the form, I can upload file and I can download the attachment from the form.

Now, I have a grid which is created using the same table (i.e. table1). I created a new field called “attachment”.
For this new field, the data type, I select “Document (File Name)”.

However, when I view from the grid, I did not see and link under the column “attachment” which I have uploaded via the form.

Can anyone advice? Thanks.

#2

since your filename of your uploaded file is in another table (document_upload) and the grid based on your table1, there is no link between them. You can use a lookup for your attachement-field to search for the filename(s) based on the id.