I want to create a form that makes it possible for a user to upload any number of files together linked to a news posting. I read in the FAQ that Pure ASP Upload cannot do multiple inserts, but would it work to put the file references in a separate table (using Access 2000) and link it to the ID of the news post?

This is what I was thinking:
1. User posts new item, and gets a form.
2. The form has a file attachment field.
3. When the user uploads a file and submits it it is inserted into a separate file table which has a field that is the post ID. Every file gets its own ID.
4. When the user submits the main form, all files are already in the database.
5. When someone looks at the post it shows all text as well as all files that has the same ID as the post.

Of course I could just create a number of file fields in the "news" table, but that would be kind of limiting, and ugly as well ...

I'm sorry if I can't really explain this well, but I hope any of you gurus can give me a hint here <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>