Results 1 to 5 of 5

Multiple attachments for each Drawing No

  1. #1
    masoud_sedighy is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Dec 2011
    Posts
    77

    Multiple attachments for each Drawing No




    I would like to make a drawing management for my self.

    I have made a list that it has some columns like below

    Drawing no
    Title

    Also I want to make a document library that it has lookup column to the drawing no column of list.
    Now I want to attach a Auto cad file and pdf file for each drawing no.

    Now i do not know for solving my problem and also controlling versioning I have to create Document set and put files of each drawing no inside folder.


    Or I have to upload each file one by one and then select drawing no from lookup column.


    controlling versioning of files very important for me, I read some where on the net that Document Set can not change version Automatically and when we modify files inside of folder Document set, the version of Document set do not change.

    I have put my question in other forums but i did not get answer.
    appreciate for any help
    Last edited by masoud_sedighy; 07-12-2019 at 03:19 AM. Reason: adding description

  2. #2
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    7,570
    recommend don't store attachments in db. store them in known folder, with meaningful names then store the path to the folder and the filename

    you haven't provided much information to provide a helpful response which is probably why you have not got answers on other forums

    based on the limited information provided you need at least two tables

    tblDrawings
    DrawingPK
    DrawingNo
    DrawingTitle

    tblFiles
    FilePK
    DrawingFK - links to DrawingPK in tblDrawings
    DrawingName e.g. 'project Z v1.00.pdf'

    the path might be hardcoded in your code, stored in tblFiles or tblDrawings or perhaps in a 'config table'. Depends how you want to organise your folders

    research 'filedialog' for ways to select your file from a folder

  3. #3
    masoud_sedighy is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Dec 2011
    Posts
    77
    Thanks Ajax

    my question is in share-point environment. it seems your reply is about how i have to this job in ms sccess.

  4. #4
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    7,570
    sorry - missed that. I don't use sharepoint enough to be able to assist you

  5. #5
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,440
    seems like a sharepoint question in setting up a document library.

    https://www.youtube.com/watch?v=L42-npNFPGE

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 09-29-2015, 11:08 AM
  2. Multiple Attachments in different Records
    By KevinCollins in forum Access
    Replies: 1
    Last Post: 10-23-2013, 08:08 AM
  3. If and Multiple Email Attachments
    By beckysright in forum Programming
    Replies: 5
    Last Post: 12-13-2012, 03:25 PM
  4. Report drawing from multiple tables
    By Palladian in forum Reports
    Replies: 3
    Last Post: 10-08-2012, 04:11 PM
  5. Multiple Attachments To One Record
    By Dgree03 in forum Access
    Replies: 1
    Last Post: 03-23-2011, 09:45 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums