Update query (one field to match another)

[drewcp]

I have a table named "Selections Fields" and a query named "Update Match".
All of the 11 fields in the "Selection Fields" table are in the "Update Match" table also ("Update Match" has 5 additional fields).

I have a form that is tied to selection fields, so when information is entered onto the form it is saved in the selection fields table.


What I am trying to do is create an update query that will apply the information that is saved in the "Selection Fields" table to the "Update Match".


I was able to do this for 10 of the 11 fields because they where just yes/no fields. The field that I need this for is called "License Number" and is a text field.

If anyone has any suggestions on how I can do this, it would be Greatly appreciated. Please let me know if my description was clear enough.

Thank you in advance

 

[MajP]

This seems pretty non normalized, any reason you are copying the same information in two tables instead of a foreign key to the Selection Field table?

tblSelectionFields
selectionField_PK (primary key)
field1
...
field11

tblUpdateMatch
additionalField1
...
additionalField5
selectionField_FK (foreign key to tblSelectionField)