relate tables - please help

L

Lasitha

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....
 

Ask a Question

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. After that, you can post your question and our members will help you out.

Ask a Question

Top