Results 1 to 5 of 5
  1. #1
    Kevin51 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jun 2017
    Posts
    3

    Choice Field Being Moved to End of Table


    I have a SharePoint list choice field which allows multiple selections. It is meant to appear in the 8th column of the table of 41 columns and is set up this way in both 'column ordering' and the default view settings in SharePoint. Unfortunately, when I open the linked table in Access this column always appears at the end. I can move the column to where it should be in datasheet view and save but each time the linked list is refreshed the column moves to the end again. Any help would be appreciated.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    I am not entirely sure what you're asking here if it's a table design question if you have a form open that access the table in question it will not allow you to change the design.

    Further than that though, you should avoid having a single field store multiple values, I know it's an option in some MS access versions but it's an incredibly bad idea. you should look into data normalization, if you have a one to many relationship between pieces of data that should be reflected in your table structure.

  3. #3
    Kevin51 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jun 2017
    Posts
    3
    Thanks for your reply. This has nothing to do with forms - it is just a linked table in Access coming from SharePoint. When I open the table in design view in Access it is read-only. I know I should be using normalization but the ability to make multiple selections in SharePoint was deemed important to my team for this database.

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Again I am really not sure what you're getting at.

    If your users are doing data entry directly on a table why? Why not give them a form so you can have a properly normalized structure? If your back end is on a sharepoint site there is nothing preventing you from having a front end that can be run on their local machine and have all the functionality you want. Even if you store the front end on the sharepoint site you can give them a database that works you just can't use vba.

    If your users are doing data entry on a LINKED table you would have to change the SOURCE table structure (change the order of the columns etc) to reflect the changes you want on the table the users see. You cannot change the design of a table that is linked. You have to change the source object. if the source object is another access table in another access database go to that source access database and modify the table. If the source table is a SQL table that you have no control over you're kind of stuck, but you can mitigate that by creating a view (on the SQL side) or query (on the MS Access side) and have your users do their data entry on the query as opposed to the table itself.

  5. #5
    Kevin51 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jun 2017
    Posts
    3
    This is helpful. I do have control of the source object which is a SharePoint list. My question is that even though I modified the view on the source side how my team wants it, it is still not showing up that way on the front-end database in the linked table. Something is causing these columns to move to the end of the table.

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

Similar Threads

  1. Replies: 2
    Last Post: 06-01-2017, 06:42 AM
  2. Replies: 0
    Last Post: 03-19-2017, 01:29 PM
  3. Replies: 5
    Last Post: 06-25-2014, 09:19 AM
  4. Multiple choice in a single field
    By fabads in forum Access
    Replies: 6
    Last Post: 05-21-2013, 11:45 AM
  5. Replies: 7
    Last Post: 10-16-2012, 06:43 PM

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
  •  
Other Forums: Microsoft Office Forums