Alpha Video Training
Results 1 to 2 of 2

Thread: Lookup values in search grid results

  1. #1
    Member
    Real Name
    Denis Ahmet
    Join Date
    Jul 2005
    Location
    United Kingdom
    Posts
    988

    Default Lookup values in search grid results

    Hi,

    Im not sure how to go about this.

    I have a grid based on a table that contains a series of ID numbers.

    ID_No
    001
    002
    223
    983

    When i view this grid, i want to automatically lookup the values of the ID numbers above and display only the names which is contained in another table.

    tbl_names
    001 Denis
    002 Jo
    223 Harry
    983 Louis

    Therefore rather than my grid displaying just a list of ID's, it will display a list of names.

    What is the best way to achieve this without having to store the name within the grid table?

    Denis

  2. #2
    Member
    Real Name
    Denis Ahmet
    Join Date
    Jul 2005
    Location
    United Kingdom
    Posts
    988

    Default Re: Lookup values in search grid results

    Solved!

    I placed a lookup in the calculated field of my grid.

    Code:
    txt    = lookup("[PathAlias.ADB_path]\tbl_ci_project_details","project_id="+quote(Project_id),"Project_Name")

Similar Threads

  1. Search In Filter Lookup Grid
    By jacklcs in forum Application Server Version 8
    Replies: 2
    Last Post: 03-17-2012, 12:59 AM
  2. Update Grid Search Results
    By scotthanes in forum Application Server Version 9 - Web/Browser Applications
    Replies: 0
    Last Post: 07-21-2009, 11:29 AM
  3. Update GRID search results.
    By scotthanes in forum Application Server Version 9 - Web/Browser Applications
    Replies: 3
    Last Post: 05-16-2009, 12:30 AM
  4. Search results incomplete
    By steinmanal in forum Application Server Version 8
    Replies: 4
    Last Post: 11-02-2007, 11:42 AM
  5. Multiple select lookup for grid search?
    By csda1 in forum Application Server Version 8
    Replies: 2
    Last Post: 09-08-2007, 03:49 PM

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
  •