Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a fairly complex data model (at least for me) and am having an issue. I'm hoping I can give a fairly high level description of the problem since sharing the complete data model and all potential factors would be difficult to do.
My data model works for what I need it to. I then added a new table that links to an existing table. But when I do, the data does not show up. The linking field is called [Financial Date].
If I rename the linking field to something else, in this case [Financial Date Temp], obviously the table will not link, but the data loads as expected.
To make things more confusing for me, when I do a data preview of the table when linked, it shows that it has rows of data, but none exist in the preview.
Here's a screen shot of the portion of my data model applicable to this question (I haven't worked to resolve the synthetic key yet, but the it does not give me any issues with the rest of the data model, so I may just leave it). This is the version when I name the field [Financial Date] the same and it links, but no data shows up. The version of the data model where the data comes in and show up is the same, but [Financial Date] is renamed to [Financial Date Temp] and the link is gone.:
Here's a screen shot of the data preview when linked and no data shows up:
Here's a screen shot of the data preview when not linked and data shows up correctly.
Both screens show 182 rows of data, but I dont get any actual data when linked.
Thoughts?
Attached is the code to generate the two tables. I added date# functions to [Financial Date] in both tables to make sure they were both the same data types, and re-ran it, but I get the same results.
Intersting note. If I create a new app, and just load those 2 tables, it works fine. So it must be something in the way the synthetic key affects it. I tried to create a link table to eliminate the synthetic key, but got the same results.
I was hoping there was a general reason why you would see, in Preview, that there are 182 rows, but no data shows.