Does anyone have suggestions

[S Tuttle]

I have a table that I want to input customer number and then go to another
table get the part number and code then automatically insert that
information into the fields in the table that I am working in.

 

[Anand.V.V.N]

Hi,
Can you be a bit more clear, do you have the table desing in place? Or you
want to link the this to another table? Or looking for a sql statement?


Anand

 

[Duane Hookom]

If I understand correctly, you might want to review the Cascading Combo
boxes sample at http://www.rogersaccesslibrary.com/TableOfContents3.asp.

 

[Jeff Boyce]

It sounds like you are trying to do this directly in the tables. Don't!

Use forms for data entry (and see Duane's suggestion re: cascading combo
boxes).

Good luck

Jeff Boyce
<Access MVP.