I have a simple table that has some fields
The 2 key fields i want to relate are DESCRITION and PHOTO
I have set these fields well in the add/edit page whereby DESCRIPTION is TEXT and PHOTO is "Document Upload" field whose image storing path i defined.
I need help in the view page.. I want the DESCRIPTION field to appear as a hyperlink which when clicked should display the PHOTO (image) stored in my "Document Upload" path. I tried the following for the VIEW AS option for the DESCRIPTION
- view as hyperlink
- url prefix images/PICS/
When viewed in browser, the image cannot be displayed since the proper path is not listed in the address bar..
eg:
images/PICS/food
instead of images/PICS/pic.jpg
where food is the DESCRIPTION field.
Please help