Alpha Video Training
Results 1 to 5 of 5

Thread: Multiple answer table lookup

  1. #1
    Member
    Real Name
    Kelley Martin
    Join Date
    Nov 2006
    Posts
    32

    Default Multiple answer table lookup

    I have created a Invoice form for selling of valves. I created a browse for invoice items with the following fields:
    Item Number
    QTY
    Partnumber
    Price
    SerialNumbers (field rules, table lookup)

    If Item 1 has a qty of 5, I would like to select 5 different serial number that correspond with the partnumber and the valves that will be sold. (Each valve has a unique serial number.)

    I set up a table look up for that field to be able to select serial number. Is there a way that I can select more than one for that one field?

    Thanks,
    Kelley Hebert

  2. #2
    "Certified" Alphaholic Mike Wilson's Avatar
    Real Name
    mike wilson
    Join Date
    Apr 2005
    Location
    Grand Rapids, Michigan
    Posts
    4,212

    Default Re: Multiple answer table lookup

    Kelly,
    Yes, but you are describing uniqueness. If each item is unique by a serial number, I think you are going to have to have it as an itemized individual item with a serial number field so it come out as:

    Invoice_no....item_no.....part_no.....serial_no.....price

    with 5 listings.

    If you only want one listing for the item number-partnumber, then a child table with a 1-Many set can hold the values of the serial number. For this I might think about a concatenated field = invoice number + part number.

    Code:
    Parent:  Invoice_no....item_no.....part_no....inv_part....Quantity.....price
                                                     II
    Child:                                         inv_part.....part serial_no
    There are likely other ways.
    Mike W
    __________________________
    "I rebel in at least small things to express to the world that I have not completely surrendered"

  3. #3
    "Certified" Alphaholic DaveM's Avatar
    Real Name
    Dave Mason
    Join Date
    Jul 2000
    Location
    Hudson, FL
    Posts
    6,027

    Default Re: Multiple answer table lookup

    is there a portion of the serial number that is always the same?

    If the first 8 digits are always the same, you could have a search on the first 8 or have an exra field that is calculated when the valve is inserted into the valve table as your lookup field. This is just another way, but I use it in the auto industry

    Example: all ford falcon 2 drs 6 cyls started vin number with 2xgt435x, so I do my lookup on the first 8 of the vin and get the vehicle to pop up.

    Dave

  4. #4
    "Certified" Alphaholic Mike Wilson's Avatar
    Real Name
    mike wilson
    Join Date
    Apr 2005
    Location
    Grand Rapids, Michigan
    Posts
    4,212

    Default Re: Multiple answer table lookup

    Dave,
    sounds like the VIN for cars is like a concatenated part number(car type) and serial number. Interesting.
    Mike W
    __________________________
    "I rebel in at least small things to express to the world that I have not completely surrendered"

  5. #5
    "Certified" Alphaholic DaveM's Avatar
    Real Name
    Dave Mason
    Join Date
    Jul 2000
    Location
    Hudson, FL
    Posts
    6,027

    Default Re: Multiple answer table lookup

    Part of my vinlook.dbf. It holds a lot of history.

    Dave

Similar Threads

  1. Multi-table query -> answer table?
    By Daniel Hofer in forum Alpha Five Version 7
    Replies: 5
    Last Post: 04-13-2006, 10:36 AM
  2. conditional lookup multiple tables
    By jean-pierre in forum Alpha Five Version 7
    Replies: 1
    Last Post: 02-16-2006, 02:59 PM
  3. Multiple Lookup Tables
    By Heather Robinson in forum Alpha Five Version 6
    Replies: 2
    Last Post: 07-24-2005, 11:49 AM
  4. Data Entry - Multiple Lookup
    By David Boomer in forum Alpha Five Version 5
    Replies: 5
    Last Post: 01-02-2003, 01:19 PM
  5. Best practices: Multiple lookup, write to table
    By Evan Dembskey in forum Alpha Five Version 5
    Replies: 3
    Last Post: 09-10-2002, 03:56 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •