Skip to main content
List Manager logo
List Manager Forum

Input values only from available values in another table

User moon_1167

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

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

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

Moonsoft support

Ok,no problems, glad it helped.
Best regards

...
Support/development

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

Buy now!
...
Support/development 40 hours

With the peace of mind of having a professional team at your service (20% discount)

Buy now!