Snapshot Update
I have 2 tables - Table A and Table B - that are related.
In the records in Table B I have a field - Field A - that is a lookup field back to Table A.
I also have a field in Table B - Field B - that is a snapshot of Field A.
The logic is if a user does not have permission to view the related record from Table A then Field B is displayed on the forms for Table B. If they do have permission they will see Field A.
The issue I have is that if someone edits Field A in Table A naturally the snapshot field, Field B in Table B, is not updating given its nature. To update I need to review an exception report and manually update Field B by re initializing the field for existing records.
I am wondering if there is possibly a solution to this that I am missing? Could I 'trigger' an update of Field B somehow through a table-to-table import or something different? I am thinking not however would be keen to hear before tackling a possible rebuild of my architecture.
Thanks,
In the records in Table B I have a field - Field A - that is a lookup field back to Table A.
I also have a field in Table B - Field B - that is a snapshot of Field A.
The logic is if a user does not have permission to view the related record from Table A then Field B is displayed on the forms for Table B. If they do have permission they will see Field A.
The issue I have is that if someone edits Field A in Table A naturally the snapshot field, Field B in Table B, is not updating given its nature. To update I need to review an exception report and manually update Field B by re initializing the field for existing records.
I am wondering if there is possibly a solution to this that I am missing? Could I 'trigger' an update of Field B somehow through a table-to-table import or something different? I am thinking not however would be keen to hear before tackling a possible rebuild of my architecture.
Thanks,
