Results 1 to 3 of 3
  1. #1
    lookingforK is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Oct 2012
    Posts
    31

    Question How to change item source for a multi-valued field from a linked table to a list?

    Hi,

    I am using MS Access 2007.

    I have created a multi-valued field "Product Category" that lookups data items from a linked table. So, the Data Type for the multi-valued field "Product Category" is Number.



    Now I want to change the Data Type of "Product Category" from Number to Text, and make a value list that I can type values in and can provide the same data items as the linked table.

    How to change item source for the multi-valued field from a linked table to a list that I can type in values?
    Is there a feature provided by MS Access 2007 can enable such a conversion?


    Thank you in advance.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Instead of saving the numeric ID key from the lookup table you now want to save the descriptive text and abandon the lookup table?

    You should be able to just change the field type from number to text but changing the saved data without having to manually edit each record will probably be tricky. Review https://www.accessforums.net/program...vba-21259.html

    Just another reason not to use multi-value fields (I never do).
    Last edited by June7; 02-17-2013 at 06:03 AM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    lookingforK is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Oct 2012
    Posts
    31
    Thank you Jane7,

    Will check your reference.

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

Similar Threads

  1. join two tables on multi-valued field
    By smudger in forum Queries
    Replies: 3
    Last Post: 06-17-2012, 03:12 AM
  2. Replies: 2
    Last Post: 04-05-2012, 08:39 PM
  3. Replies: 5
    Last Post: 12-18-2011, 09:12 PM
  4. Multi Valued field sort
    By bugman61 in forum Reports
    Replies: 2
    Last Post: 08-06-2011, 11:45 AM
  5. Append Query - Multi-Valued Field
    By catat in forum Queries
    Replies: 0
    Last Post: 05-11-2010, 01:52 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
  •  
Other Forums: Microsoft Office Forums