I'm a APEX newbie using APEX 4.1. I have a table with engineering drawing information (drawing number, title, revision, etc.) and another table with the corresponding drawing files (pdfs stored as blobs where the filename is the drawing number with a pdf extension). The user wants to search for a particular drawing by drawing number from the drawing info table and if the drawing number exists in the drawing files table the drawing number will also be a download link for the file, if the drawing number doesn't exist in the drawing files table than the drawing number will display as plain text (not as a download link).
Is this possible and if so how do I do it? Any help would be appreciated. Thanks.
Start by looking at this link: http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21674/advnc_blob.htm
Then look at adding conditional logic in your query to display the link only if you find an associated item in your joined table..