H
He cries for help
Can someone walk me through the steps for creating an update query? I have
two tables named "posnow" and Suppliers. both contain the same fields
"suppliers, contact, telephone and fax". (The supplier table contains the
information and the posnow table is the main design table)
I want to auto update fields on a form with the same name using this query.
Also should what should be used on the form, a list box, combo box or other
to look up the main field(supplier) to fill in the balance of the fields?
Please be definitive with you anwser for I am just a amatuer at this. Thanks
for you help...
two tables named "posnow" and Suppliers. both contain the same fields
"suppliers, contact, telephone and fax". (The supplier table contains the
information and the posnow table is the main design table)
I want to auto update fields on a form with the same name using this query.
Also should what should be used on the form, a list box, combo box or other
to look up the main field(supplier) to fill in the balance of the fields?
Please be definitive with you anwser for I am just a amatuer at this. Thanks
for you help...