not sure if table A is the parent table of table B or not. If so,
edit at least one field in the Table A
Yes i should have mentioned:
Table A and be are not Related. Table A by definition must be edited, because it is that edited field which is being placed into Table B.
Ie: Field one table A is changed. This new value is supposed to be copied into Field one of Table B via API_editRecord. The edit record seems to happen before the change of Field one of table A is registered.
Update: It really does not matter about tables. I tried this in a test environment with a simple:
EditRecord Api that places Field A, into Field B (Same Table, same record). If you use this api in edit mode (so you change field A, press the button and allow the record to AutoSave), the first couple of times it works exactly as expected. Try a few more times, and it will no longer work. When you modify field A and press the button, it seems to Grab the original Field A value, THEN autosave, then run the editrecord API.
The strange thing is, the first time, sometimes two times it seems to work correctly (autosave, grab field A value, then edit record). I am baffled why it is inconsistent. I made a video documenting this but the attachment here will not allow attaching videos. I have submitted a customer support ticket and can update here if they respond, but wondering if others have found this behavior.
