I have two tables. Table A with Column A (Text Data). Table B with Column B (Lookup Data from Column A)
I have a Button that I would like to cause the following changes:
adds new rows to Table B
Pull the current status of Lookup Column(A) to Column B
I’ve partially accomplished this task, however the issue I run into is thus…
When I change the Data in Column A, when the button is pressed Column B doesn’t populate the changed data. I have to manually reselect the values in each row.
Is there a way to automatically update a lookup column?