Linked table look up ??? HELP.

[KaiProton]

OK, so now in my Dbase Ive got the main data, and another table with 2 fields in,

in the second table its a part number and a weight,
on the main data I need the user to select the Part number with a combobox that the weight is filled in the maindata automatically, I dont understand Relational Dbases, yet so if anyone knows how I can do this, please explain in little words, lol


I did manage to do this earlier in the dbase with box sizes and weights but as there are only 4 size of box I coded it into he VB, but with the caps there could be up to 100 different caps.

Anyone HELP PLZ.

 

[KaiProton]

EEk!

Eek!
Query,

I will look into making a query to do it,

to do it I guess the query needs to be in SQL and when the first field is item1 the sql looks up the weight field to be item 1's weight

 

[KaiProton]

I like the idea of using the query bulider, Thanks, I will try it as soon as I get in work