Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
relate tables - please help
9 views
Skip to first unread message
Lasitha
May 25, 2012, 12:02:22 AM5/25/12
to
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....
=======
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....
0 new messages