Help: A view that uses values from one table to display info from another table.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jason Csizmadi (jcsizmadi_at_bozelljacobs.com)
Date: 06/09/04

  • Next message: alex: "OWC PTS error 0x80070005" 
    Date: Wed, 09 Jun 2004 16:28:06 -0500

    Išve got a question about setting up a view that collects information from
    one table based on the values entered into another table.

    I have table one with four integer fields. I need to create a view the uses
    the fields values in table one and displays the information from Table two.
    Table two cmd field is linked to both the (name one) field and (name two)
    files of table one. What I want displayed in my view is the variable content
    in table two instead of the integer values from table one.

    If anyone has clue to how to do this please respond to this post.

    Table 1
    ____________________
    Cmd / int/ 4
    ____________________
    Sort / int / 4
    ____________________
    Name_one / int / 4
    ____________________
    Name two / int / 4
    ____________________
    ++++++++++++++++

    Table 2
    ____________________
    Cmd / int/ 4
    ____________________
    Name / varhcar / 50
    ____________________
    ++++++++++++++++

    Desired View
    ____________________________________________________________________
    Sort | Name one | Name two |
    ____________________________________________________________________
    1 | Content 1 | Content 2 |

    The View I get
    ____________________________________________________________________
    Sort | Name one | Name two | Name |
    ____________________________________________________________________
    1 | 9 | 10 | Content 1 |

    Sent using the Microsoft Entourage 2004 for Mac Test Drive.

  • Next message: alex: "OWC PTS error 0x80070005"

    Relevant Pages

    • Re: resize JTable
      ... >able to easily sort the data, from a user point of view. ... public static final int DESCENDING = -1; ... private Comparator comparator; ... * @param model OrderedTableModel to be kept deduped/sorted. ...
      (comp.lang.java.programmer)
    • Polling for devices other than NICs [patch]
      ... interrupts for everything) in the driver, ... em_start_locked;} static void -em_poll(struct ifnet *ifp, enum poll_cmd cmd, int count) +em_poll{ ... static void -fwe_poll+fwe_poll{ ...
      (freebsd-hackers)
    • Re: Polling for devices other than NICs [patch]
      ... #ifdef DEVICE_POLLING static poll_handler_t dc_poll; static void -dc_poll(struct ifnet *ifp, enum poll_cmd cmd, int count) +dc_poll{ ...
      (freebsd-hackers)
    • C Sharp sorting considered superior to C by an order of magnitude
      ... following sort algorithms and the following points. ... its own comparision for the types bool, byte, short, int, long, ... single, double and string. ... private CheckBox CHKdeterminism; ...
      (comp.programming)
    • Re: "Sorting" assignment
      ... If the array is already sorted, this means that you end up ... attempt to sort them. ... int quicksortPartition ... for (intIndex1 = intLeft; ...
      (comp.programming)