hey, sorry for the confusion,
i actually got the update query to work for me pretty much the way i wanted
it to work. but now there's another limitation.
actually i got one table that holds the entire product data. i created a
user-friendly order form that inputs data to table 2 for my supervisor to see
the orders placed by students. the way it works is , the students search for
the products from the main table and feed in only the seriel numbers in the
order form. my supervisor wanted table 2 to automatically fill out the rest
of the fields for the records based on seriel numbers alone, from the main
table. i got that working . but there's another form(form B) that the
students use to place orders for products that are not present in the main
database, for this form they have to manually fill out all the fields for the
order they're placing.Both the forms r linked to table 2 . now when i run the
update query, it erases all the records entered from form B since those
records don't have a seriel number, my supervisor wants to assign the seriel
numbers to these new products later. is there a way that the query only
updates the records with seriel numbers only and doesn't affect the records
without the seriel number, in table 2.
Thanks for your assistance so far.