Join issue

[jeffhoneyager]

Table Reject
id
reason_id
...other fields

Table Reason
id
reason_code
reason_description

I create a join
- type = Left
From = Reject
To = Reason
From column = reason_id
To column = reason_code
Repeatable = yes

When displaying data the fist entry in the Reject table seems to look up and display the info from the Reason table, then no other records seem to show. In all other listing (lines) the Reason.reason_code and the Reason.reason_description are empty.

????

Thanks

 

[troester]

In Fabrik one "leg" of the join must be a primary key, so e.g. from Reject.id to Reason.reason_code