references lost

Hi,

a strange thing happened to me.

I have 3 tables
Projects
Jobs
Users
Users is a child of jobs which is a child of projects.
I generate a final pdf and everything works fine.
I changed the data type for the ref column in the Users table from ref to text by mistake. I reset it to ref, but since then the pdf does not work and I find this error Start expression '[Users]' should generate a List of Ref values.

I have tried everything, delete and recreat the users table, delete the virtual Related Users column in the jobs table, but nothing.
As proof I tried changing the data type for the ref column in the jobs table, and when I generate the pdf it gives me the error Start expression '[Jobs]' should generate a List of Ref values.

Can anyone help me?

Solved Solved
0 2 125
1 ACCEPTED SOLUTION

Can you please send a screenshot of your data structure and the pdf template?

View solution in original post

2 REPLIES 2

Can you please send a screenshot of your data structure and the pdf template?

Thanks for your answer, 
your question helped me to find the solution. The related column name  was wrong.

Top Labels in this Space