hi crew i am super newbie:
I just have 2 tables 0ne table with
a)3 fields, bodypart(autonum), partname(text), Code(#),Code2(#)
b) 3 fields Lname, fname, date, code
What I want to achieve is lets say a client comes, and I type bodypart 10, how can the partname and Code show automatically...