Forum


List Manager Support

List Manager support
Forums
No se permite escribir sin estar logado. Por favor, login

Input values only from available values in another table 10.07.2013 17:01

Hi,
I'm trying to allow a front-end user, which is filling a new record in an existing table, to choose, for a specific field, among the values already present in another table.
As an example: I have a pre-compiled table with a number of car's models (let's say: car-1, car-2, car-3). Then a front-end user inserts its own data in a different table (having fileds: name, address, ..., car model), where the owned car can only be selected (with a drop-down menu?) among car-1, car-2, car-3.

Would it be possible?
Thanks
Best Regards
Fabio

Re: Input values only from available values in another table 10.07.2013 23:17

Hi,
in order to create an option list with values recovered from another db table, you need to set the field as an option list, and configure it to use values from a query to your database. You can find details on how to configure this option at pages 8/9 of the quick guide, with an example of recovering values of the menu table.

Hope this helps, regards
Moonsoft Team
www.moonsoft.es

Re: Input values only from available values in another table 15.07.2013 11:51

Thanks, that's very usefull.
I understand I should had check the manual before writing, so a double thanks to you.
Fabio

Re: Input values only from available values in another table 17.07.2013 22:32

Ok,no problems, glad it helped.
Best regards
Moonsoft Team
www.moonsoft.es
Are you satisfied with our products/services/support?
Please help us to keep improving, add a review at  joomla extensions site and  magento connect
FaLang translation system by Faboba

Lo que nuestros clientes opinan de nosotros