Hi
I have one lookup field between two forms. When I select a view combining fields from both forms my lookup field appears in the report header but the contents of that field are empty. Do I need to link the two forms in some other way in addition to the lookup field?
I have followed "Creating_a_relationship_using_single-select_lookup_field in the documentation." The form builder links the two forms and I can select the additional fields from the second form and enable them in "column view".
The first [Company] form fields include:
Company Name
Industry type [lookup field]
The second [Industry Classification] form includes:
Industry Description - this is the drop down field shown in the first form
When I display a view including "Industry Description" that field is blank for all the records.
Do I need to add a further script to enable the lookup to function correctly between the two forms?