Hi all, pls assist in a update query in 2007, I have two forms with different info and a 3rd combining it by a dropdown box, one form with info from two different tables, there is no common field between the two tables, I need to update a 3rd table. I tried using criteria from the form but it only displays a zero output. attached is a screen shot of the qry. I have added the ID field to second table from 1st table for the sake of the update qry.
,
Last edited: