Forum Discussion
Values disappear when changing colum order in table
Hi all,
Table 1 and table 2 have 1_to_many relationship and data is showing in the table below and correct.
Columns are selected to "show items with no data" same as LEFT JOIN in SQL. This means that data in Table 1 is still showing even Table 2 have empty values.
However, when I swap two last columns "Table 1_Moisture" and "Table 2_Moisture", then values of Table 1_Moisture disappeared as the screenshot (question marks) below.
I want these values still appear when changing the column order
Thanks
3 Replies
- MahyarTF
Memorable Member
Hi,
Not sure what is your sample data and your data-model,
But I tried to simulate the scenario for myself and it seems all correct :
- AnonymousNot applicable
Hi MahyarTF,
This is my data model,
It is also weird for me and not sure why
Thanks
- MahyarTF
Memorable Member
I saw your data model, My sample is the same.
it is weird.
Appreciate for Kudos