List Manager Forum

Input values only from available values in another table

User moon_1167 2013-07-10 17:01:35

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

Moonsoft support 2013-07-10 23:17:26

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

User moon_1167 2013-07-15 11:51:08

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

Moonsoft support 2013-07-17 22:32:28

Ok,no problems, glad it helped.
Best regards

...
Support/development 10 hours

Get a bigger amount of hours for more complex tasks and get a 10% discount

Buy now!
...
Support/development

Perfect for small code changes or to correct any bug at your site

Buy now!