Can someone clarify the following:
I have two tables, created on the same page, but one is not a view of the other.
In tabel one I am doing some work and it has a button collumn. Upon hitting the button, some fields in the active row are changed. Through automation, when a certain field value changes, I take some data (three fields) and add them to a new row in the 2nd table. On some rows I do this once, on others I do this multiple times.
At the end of the session I might have 15 rows in table one (however many I have added), but hundreds in table 2 (depending on how often I have hit the button).
I would think that the data in table two is independent from the data in table one, but If I change the data in the original field (say a persons name), it gets changed all over the place. Or, If I delete the orinal row in table one, the data in table two is incomplete.
So, I guess I am not making rows with text/numerical data, but rows with links to the originating field.
- is there a way to populate table two with the value of the data from table one instead of a link to that data (so it becomes a truely independent tabel)
- is there a way to prevent rows from being deleted (either on purpose or by accident)