Its about linking 2 tables

[desertsolider]

i have 2 tables in a database that i want to link some field like whn i choose some detail lets say a table containing this fields

Table1: ID Name Number
Table2: Number Number code

when table1 number = * , i want its number code

I cant explain well i hope u understand me , but plz this is very imp and i am nt a very good at vb thx

[desertsolider]

IF u Guys dun understand thiss let me explain but help me plz