How to get Relevant code

[Lasitha_kamalpriya]

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 TABLE1

INVOICE METHOD GRADE QUINTITY

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_kamalpriya]

but can It apply to table?

 

[speakers_86]

No. You do not want this applied to tables. The end users should never see the tables, only the forms.

 

[Lasitha_kamalpriya]

I could get your instance from this page

Ken's Sample Databases

thanks Mr.Hartman