Autofill dropdown from table

Hi everyone
I know it has been asked in this forum before but none of the solutions is near to what I am looking for and I can't figure out on how to do this with chronoforms. I am sure it must be possible, but simply can't find the answer to my problem.

I have created a table called tbl_prijslijst.
This table contains following fields
categorie, merk, artikel, aantal, prijs_excl_btw, btw_code, artikelcode, opmerking and afbeelding

What I would like to accomplish is following

When a user selects artikel (which should be populated from the table), the other fields should automatically be filled with the corresponding data from the table

Furthermore, I'd like to add the option, for instance a [ + ] that can be used to call another line where anohter artikel can be selected.

Seems straight forward? Might be, but I have no clue on how to accomplish this. As an example

Artikel [dropdown] aantal [ ] prijs_excl_btw [ ] ........

[+] add another artikel

Artikel [dropdown] .............

Problem I am facing is that Chronoforms seems to be a GREAT program, but there are not that many working examples available and documentation is rather short in this..

Can anyone throw in a helping hand?

Tks + best regards

Gino

Hi Gino,

Please see this FAQ for the drop-down question.

Please see this FAQ for adding extra inputs.

You will need some experience with JavaScript to get these working in the way you describe above.

Bob