The steps I want to take are the following and the BOLDED part is where I'm stuck:
- Autoincrement 'Table A'[ID] Column when "New Row Added" to 'Table A'
- Auto "Add New Row" in 'Table B' when 'Table A' "New Row Added"
3. Auto Select/Update/Overwrite 'Table B'[ID] Column to link to the newly added row in 'Table A'
I can get the value in 'Table B'[ID] Column overwritten to the actual value from 'Table A' but the cell merely holds the value and isn't linked to the related row in 'Table A'. (E.g. if 'Table A'[ID] value is 1, 'Table B'[ID] will also hold the value 1, but will not be linked).
What do I need to do to get it the new added row in Table B to link to the row it derived from in Table A?
Actual example would be:
Click on new row for Table A.
Table A[ID] is now 1.
Row is created in Table B.
Newly created row in Table B is linked to Table A row that was just created and Table B[ID] also reads 1.