[SOLVED]CDD not show same value when Add record VS Show list

[samani]

hi.please see this short video:
https://www.screencast.com/t/xccILq4DmetE
in brief you can see in the user_course table(pic attached please use fullscreen mode) when i have one user that enrolled in 2 course, it's repeated 2 time in the list view in but show 1 time in the adding(or editing) record page.
i guess have problem in the cdd setting or needed to maybe have to use Advance Where tab.
tnx and waiting for your reply.

 

[cheesegrits]

The 'id' in your CDD data setup should be 'id', not 'user'. The value you store MUST be unique. Almost always the PK of the table you are joining to, which in Fabrik is usually 'id'.

You are storing 'user' as the value of the CDD. So as soon as you have more than one row with the same 'user' in the joined table, the list selection will see both of them, because we're joining from the CDD value to 'user' ... which yields two rows.

-- hugh