Skip to main content
Participant
November 14, 2006
Question

Attachments with Records

  • November 14, 2006
  • 1 reply
  • 230 views
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?
This topic has been closed for replies.

1 reply

Inspiring
November 14, 2006
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.