Forum
List Manager Support
List Manager supportForums
Public write access is disabled. Please 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
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
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