Attachments with Records

[malangon]

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?

[MrBonk]

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.