relate tables - please help

Discussion in 'Access VBA Modules' started by Lasitha, May 25, 2012.

  1. Lasitha

    Lasitha Guest

    METHOD TABLE
    =======
    CTC
    ORT
    ---------------------------



    TEA GRADES TABLE
    ================
    METHOD TEA_GRADES
    CTC BP1
    CTC PF1
    CTC D
    CTC D1
    ORT BOP
    ORT FF
    ORT OPA
    ORT PEKOE
    ---------------------------------------

    There is two tables called tea method table & tea grades table....
    now I need to create a new table called INVOICE TABLE

    INVOICE METHOD GRADE QUINTITY
    (UNIQUE) (from (from (kg)
    method grade (enter
    table) table) manually)

    001 CTC D1 2000

    002 CTC PF1 1000

    003 ORT PEKOE 1500

    004 ORT PF1 1750

    *problem with last row grade


    here I have lookup METHOD & GRADE from above mentioned tables but in
    this grade column last row PF1 belongs to CTC grades. that is not
    correct.... I need to get only relevant grades when I select CTC or
    ORT from METHOD column....
    please help me... thanks in advance any help....
     
    Lasitha, May 25, 2012
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Steven Ferguson

    Rename a table in code (NEED HELP, PLEASE, PLEASE)

    Steven Ferguson, Jan 15, 2004, in forum: Access VBA Modules
    Replies:
    2
    Views:
    99
    Joe Fallon
    Jan 16, 2004
  2. Ashish Kanoongo

    Linking of Tables/Refrittled Tables

    Ashish Kanoongo, Feb 17, 2004, in forum: Access VBA Modules
    Replies:
    0
    Views:
    115
    Ashish Kanoongo
    Feb 17, 2004
  3. Risha
    Replies:
    3
    Views:
    279
    Ken Snell [MVP]
    Apr 2, 2005
  4. Gail H
    Replies:
    1
    Views:
    169
    Alex Dybenko
    Sep 1, 2005
  5. DaveO

    ADO: JOIN vs RELATE.

    DaveO, Jul 13, 2006, in forum: Access VBA Modules
    Replies:
    1
    Views:
    141
    Barry Gilbert
    Jul 13, 2006
  6. Nat1

    backup linked tables to local tables?

    Nat1, Jul 18, 2007, in forum: Access VBA Modules
    Replies:
    1
    Views:
    154
    John W. Vinson
    Jul 18, 2007
  7. FatMan
    Replies:
    1
    Views:
    72
    John Spencer MVP
    Jun 1, 2009
  8. sam
    Replies:
    9
    Views:
    177
    Bill Mosca
    May 4, 2010
Loading...