query to generate coding sysytem

[shanky365]

hello all
i have a table with pipes diameter, other table with pipe material , other with grade or type.
nw its like dis. table for diameter:
ID DIAM in inch
1 1
2 1.5
3 2
n so on
Similarly, with material table n grade tble.



nw , i want to get a query where a person selects the dia, material n grade frm dropdown menu. n we shud get corresponding nos (ID) as output.
Eg if sum1 selects dia 1.5 we shud get code as 2 (id)

[alansidman]

What is the common field for your tables so that you can join them. By the way, I found your text messaging usage confusing. Make it easy on us old guys to help you and write in clear full text. If I can't understand your needs, I can't help you.

Alan

[shanky365]

Oh Sorry! i will see to it now.