H
He cries for help
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...
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...