1 Reply Latest reply on Nov 14, 2006 3:43 PM by MrBonk

    Attachments with Records

      I am using Dreamweaver with Coldfusion 7 MX and an Access database. I would like to offer an "attachment area" with each record so a user can upload a file to the server and have that attachment associated with the record. Can somebody offer me advice on how best to do this?
        • 1. Re: Attachments with Records
          MrBonk Level 1
          It's going to depend highly on the structure of your database. You'll need at least:
          1. A unique identifier assigned to each 'attachment'.
          2. A table to store the identifier and associated 'attachment' name/whatever.
          3. A field in the table your 'record' is in to store the identifier.

          You really need to provide some more specifics about your data/database/app for a more specific answer.