collect data from multiple forms

collect data from multiple forms

Hello All,

I have an issue to collect date from two forms into one report. I've created the lookup relationship between the two forms, I can see the fields Would need from the other form, but there is no value in the field in the pivot table. Though if I open the form, and check the lookup field I can see the values I would need in the report.

Any tip please what I made wrong?

Kind regards
G