Results 1 to 2 of 2

MS Access Sharepoint - Copy Table Data/Relationships

  1. #1
    jambajamba is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2016

    Question MS Access Sharepoint - Copy Table Data/Relationships

    I am a newbie and since the days when i first dabbled with Databases and Access was over 10 years ago. A lot has changed or i have forgotten a lot of things. So at work, we thought of using a MS access for job issue tracking and using a sharepoint template. Looks good as everyone can access it.

    Only issue is that i have imported a customer spreadsheet (table) with all our current customers on it but i just cannot link it. See the attached. Now majority of querys and macros i have read online dont work with sharepoint, not sure why it is limited.
    Can someone please help in telling me what i need to do so the on the Issue Form - the user can type in the name of the customer and instead of the new list being fetched, it fetches our current customer list.
    Either way, copy the table from to the another, or changing the list it fetches i just cannot work it out. PLease helppp. Thanks
    Below is our relationship, new list and imported listClick image for larger version. 

Name:	relationships.JPG 
Views:	10 
Size:	50.0 KB 
ID:	25468Click image for larger version. 

Name:	newlist.JPG 
Views:	10 
Size:	33.4 KB 
ID:	25469Click image for larger version. 

Name:	eee].jpg 
Views:	10 
Size:	26.7 KB 
ID:	25470

    Thanks in advance, i spent 2 days trying to figure it out, not sure if MS restrict this change or if its my inability.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    if the fields from the CUSTOMERS table are not displaying the 'correct' information, I would guess you aren't linking on the correct field, or the CUSTOMER field in the ISSUES table is reflecting a different/unrelated customer number. Alternately, if you are importing this data from a text file, it looks like your ID fields are set up as autonumbers, and if that's the case you are creating a primary key on the import and you would need to connect the CUSTOMER field on the ISSUES table to the COMPANY name on the CUSTOMERS table because it looks like your COMPANY is a text field, not a numeric field.

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

Similar Threads

  1. Replies: 1
    Last Post: 07-23-2015, 01:23 PM
  2. How to copy data within the same table?
    By price12 in forum Access
    Replies: 1
    Last Post: 04-23-2014, 07:34 PM
  3. Replies: 0
    Last Post: 07-31-2012, 09:33 PM
  4. copy data from one table to another
    By Sureshbabu in forum Access
    Replies: 1
    Last Post: 01-08-2012, 12:27 PM
  5. copy data from text file into table in access
    By miziri in forum Programming
    Replies: 3
    Last Post: 08-12-2009, 02:02 PM

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