Hello, i have a main table, and i want to create a macros so when the user clicks on a button, it pulls data from a particular field from another table and updates it to the same field in my table. is this possible?
both tables contain the same ID's as an identifier. however, the table that is updating my main table does not have a primary key and must stay that way.
thanks!