CDD and/or DBJ showing repeated data in list, but correct in the form

[thellie]

Going back to a thread which Hugh helped me with a while back, I used the following as a basis to get the title of an element from a third table. It's working fine in the form view, but not in the list view.

(SELECT name FROM table2 WHERE table2.id = {thistable}.element)

My code is:

(SELECT option_name FROM extra_options WHERE extra_options.id = {thistable}.trek_extras)

It's showing a single name correctly in the form, but repeats for every instance of the name in the table_repeat_element table. Attached pics make it clearer, hopefully.

I can't work out why...

 

[cheesegrits]

I'd need to look at your site to figure that out, but I can't do that in Community support. If you'd like to take out a support sub, I'll take a look.

-- hugh

 

[thellie]

Unfortunately, the foundation I work for can't afford to fund a support subscription. I have to build the website(s) on the down and dirty...

But the good news is that I worked it out myself - the id setting for the element was incorrectly set. All sorted

Is there a 'solved' button for these threads?

 

[troester]

You can close solved threads by unchecking "open" in Thread Tools.