Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › Digital File Pro › retrieve upload in details page?

retrieve upload in details page?

Thread began 2/08/2012 2:58 pm by gary.brett434358 | Last modified 12/19/2015 6:58 pm by gary.brett434358 | 2915 views | 10 replies

2/09/2012 7:55 amgary.brett434358

Originally Said By: Jason Byrnes

so you are creating a one to many relationship, to do this, you need to have a cases table and a files table

your files table would have a column for the file name, and a column for the caseID

when a file is uploaded, store the file name in the file name column, store the caseID for the case the file relates to in the caseID column

to create the links, you create a recordset that filters the files table on the corresponding case using the caseID column

Hi Jason, the db structure is already built and I have recordset to display the content of the documents table, this is no problem. If if cant show users the uploads then I will need to display this table on a page filtered to logged in user, but does that still leave me without the ability to format the 'filename' field to a href?

I am trying to insert the table using DA repeat table but it always returns zero records, no matter which recordset I base it on.

Cheers

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.