Results 1 to 2 of 2
  1. #1
    wirelineuk is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    1

    mutli serial numbers in one

    HI,

    I have set up a form to input information such as:



    id
    name
    import date
    serial
    export

    my problem is in there are many serials for example 1234,1235,1236 all inputed in the same box sometimes it is only 1 serial sometimes it could be 20 or more all under the same id(primary key) and i want to make a query that will prompt the user to input the serial for example 1234 and have it search and display the information

    id
    name
    import date
    serial
    export

    but with only that one serial

    thanks for your help

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    It sounds like you're using a multi value data entry field which is an incredibly bad idea. I don't know why that functionality was put into it but you are going to have a heap of trouble with this database using a multi value field.

    For instance let's say you have the following serial numbers

    12345
    123456789

    because you have a multi value field you will likely have to search using the 'LIKE' function so let's say you were looking for serial number 12345 if you use the LIKE function it would also return any records that had the 123456789 serial code.

    If you have any control over the database at all, don't use a multi value field, it's bad news and a HORRENDOUS problem particularly for newer programmers.

    Look at a more normalized structure where you'd have your serial numbers in a sub table related to your main table through a primary key field.

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

Similar Threads

  1. Mutli User Access
    By joemills62 in forum Access
    Replies: 11
    Last Post: 10-21-2011, 08:56 AM
  2. Mutli-valued fields in reports
    By austinboy_1998 in forum Reports
    Replies: 1
    Last Post: 04-25-2011, 01:36 PM
  3. Automatic Serial Numbers
    By Mitch87 in forum Access
    Replies: 9
    Last Post: 02-18-2010, 12:57 PM
  4. organizing serial numbers and quantities
    By Diomeneus in forum Access
    Replies: 0
    Last Post: 11-14-2008, 03:17 PM
  5. Replies: 5
    Last Post: 02-08-2006, 08:42 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