I have a database with two tables named "posnow" (main design table) and
supplier table(data sheet).
There is four fields named the same within each table: supplier, contact,
telephone and fax.

I want to add these fields on my main form "posnow" and have the auto update
query update the four boxes. Would you use a combo and three text boxes or
what?

I also need someone to give me a very definitive explanation on how to
actually create the query and what to do with the form afterwards. I have
spent a enormous amount of time on this problem and this is my last headache
for this database. Thanks from a amatuer at database design...