I have two tables..
Table A and Table B
Table A references Table B using a 'list' type column with formula REF_ROWS("Table B", "parent_id")
Table B's column parent_id is of 'ref' type
In Table B, I have created virtual columns to save the data of some of Table A that I use to combine with other data inserted into Table B through a form in order to create a report (pdf/xlsx)
Virtual columns are constructed as [parent_id].[Table A Column].
When I add a new row for Table B through the appropriate form, Table A's content is saved into Table B's virtual columns accurately.
I am having an issue however.
Since I am still developing the application, I noticed that when I add a new virtual column and save the changes, after refreshing, some of the previous virtual columns are outputting incorrect data even though the formula remains unchanged.
Update: I have confirmed that it occurs just by synchronizing the app without making any additional changes to the app structure. It also occurs for basic users as opposed to just admin.
Am I referencing the other table incorrectly?
This is my first experience referencing other tables.. I've heard of creating a parent table for both Table A and Table B used for creating reports, but I would expect the same behaviors to occur.
Does anyone have a clue what could be occurring?
LinkedIn
Twitter
