Adding items to a database and viewing the database entries

It's been a while since I used the forums but then again this is a good thing since it means that everything is working as expected.

I now came up with a problem and I wanted some input on how to solve it.

I have a form which stores two fields in a database table. Lets say these are Field1 and Field2.

I want to be able to show the table values below the textboxes so that the user will see when he adds a value. So I added a Multi record loader with data displayer enabled. This works fine and the values are all shown.

Now comes the hard part. I want to show only the values that equal to Field1.

So let us assume that Field1 has <A>, <B> and <C>. And then I add <A, 1>, <A, 2>, <A, 3>. I want the data to limit the results to <A, 1>, <A, 2>, <A, 3> and not include B's and C's.

I used the token to pass the Field1 value and reload the form but I get nothing.

If the token has no DB Field then the table loads. Or else if I put Field1 it shows nothing.

Any ideas?

Thanks,


Pericles

Hi Pericles,

I'm not sure that I understand your example :-(

Does the new AutoCompleter action do what you need? That will show a filtered list of choices for a text input.

Bob