Forums

Hi and Thanks in advance.
​
I am trying to something a little trickier than usual and have got stuck. My guess is on the syntax of the where clause in a read function. Any help would be great.
​

1. Have a table calling in data and displaying - no probs
2. Table has a row called Action, to display the data from two table fields in a certain way within that row. I have made a new read function, created a form view and this in tern calls a fields view with the CC in it with the data being called and displayed in the table as desired. - This is where is goes wrong.

The fields view call the data and displays it ok, but it is repeating the first entry only. Over and over. Screen Shot attached. I want it to display the data for the record it is within.
​
I have the where clause empty and the select type on first matching record. If I change either of these then I get no results at all. Again this leads me to the understanding its my where clause to have it look at an identifier for each row to tell it what to display. Am I at least on the right track?
​
If so I just don't know/understand the syntax I need to use. Help is appreciated.

It would help if you post a screenshot of your read data actions, and probably your table too.

This is the table:

​
This is the table read action:
​

​
This is the read action for the form/fields:
​

What's in the {view:Operator_Records_Training_Form} ?

And that second read data action, how is it supposed to be related to the first one?

Ive made this way more complicated than it needs to be.
​
So, I want to display these three fields:
​

​
That are being called in this array, shown in the debug:
​

​
Here:
​

​
I know I can show one of the results at a time but I want to show 3 of those 4 (Not the hot_wear). I thought of doing a view and calling in a form and fields but cant make that work. Am I on the right track? Or something else?

*sigh* show me the view please.

What can I say......I really over complicated the hell out of that one.
​
Thanks a tonne.