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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
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:
    126
    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:
    135
    Ashish Kanoongo
    Feb 17, 2004
  3. Risha
    Replies:
    3
    Views:
    311
    Ken Snell [MVP]
    Apr 2, 2005
  4. Gail H
    Replies:
    1
    Views:
    206
    Alex Dybenko
    Sep 1, 2005
  5. DaveO

    ADO: JOIN vs RELATE.

    DaveO, Jul 13, 2006, in forum: Access VBA Modules
    Replies:
    1
    Views:
    175
    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:
    182
    John W. Vinson
    Jul 18, 2007
  7. FatMan
    Replies:
    1
    Views:
    89
    John Spencer MVP
    Jun 1, 2009
  8. sam
    Replies:
    9
    Views:
    201
    Bill Mosca
    May 4, 2010
Loading...