Jump to content
  • 0

Multiple Records Per User In A Single Table



I have created a table for file uploads. I need the user to be able to upload multiple files for their profile. At the moment I have everything working fine with a single file but I cannot work out how to allow additional records to be added to the table using the same user_ID. 


Please show me the way anyone. I am sure this is something simple I am missing.





Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

Yes it was something simple I was missing... all good now. 


I'm curious on how you solved it - did you just add additional Attachment fields? Or you found something better?


One thing I did before was use a separate Attachments table, using a key field as relationship between the primary table and the attachments.

Link to comment
Share on other sites

  • 0

I encountered a similar road-block. In building a db that would contain employee information, it was requested that it have the ability to upload multiple documents/images per employee as needed. 


I ended up doing as you suggest and created a separate table for uploads/attachments. For anyone needing detailed guidance - you can easily create this relationship by following the instructions at http://howto.caspio.com/getting-started/create-a-one-to-many-relationship/ - just substitute the "notes" text fields in the instructional video with file fields. 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...