I have a form "Vendors" that loads contact information for vendors into a Vendors table. I want the records in the field 'vendor_name' to be loaded as a drop down choice in another form. Can someone point me to a tutorial or give me guidance on how to do that?
thank you,
new Chronoforms user Michael
Thank you for your prompt advice. Unfortunately I'm new, and while I experimented for a while and did my best to not have to bother you further, I just don't yet understand some of the terminology and what goes in some of these boxes. Below is a screen shot of the table in PHPmyAdmin and the screens for the Database Multi Record Loader and the Select Box 'General' and 'Dynamic' areas. Could you please tell me what I would put into each of the spots? I think then I'll have a clear understanding of what's what.
thank you very much!
Michael
[attachment=0]multirecordloader.png[/attachment]
Hi perfcomp,
On the Dynamic Data tab copy over the Model ID - vendor_list in this case - from the DB Multi Record Loader. Then add put column names from the database table in the Value Key and Text Key columns. You can either use id and vendor_name (then you'd need to add id to the Fields list in the DB action); or you can use vendor_name in both boxes.
Bob
Thanks for your help with the database multi record loader feature for my fund raising management site. I got it working, but that feature is one I will be using extensively and I only barely understand it so far, so I bought you a TALL beer to keep you on my good side 'cause I'll probably need you again. Thanks very much for your prompt help!
Hi perfcomp,
Thank you.
Bob
