Started a new job with the most recent version of Access and can't find an answer to this -
When doing a basic Update query linking two tables I want to update a field in Table 1 to a field in Table 2 - every version I've had for the past 20 years gives you a drop down menu of the table...