Key, Domain Name, Product ID
1, alasta.geek.nz, 100
2, alasta.net.nz, 101
Product ID, Product Description
100, Mince Pie
101, Steak Pie
I have then constructed a query which joins them together like this:
Key, Domain Name, Product ID, Product Description
1, alasta.geek.nz, 100, Mince Pie
2, alasta.net.nz, 101, Steak Pie
When I use a userform to update data in the above query, I want to change 'Mince Pie' to 'Steak Pie' and have the Product ID field in the first table update to reflect the change. However, in practice, what actually happens is that the Product Description field in the second table changes while the first table remains unchanged.
What do I need to reconfigure so that this change would update the first table rather than the second table?