List Manager Forum

Input values only from available values in another table

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

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?
Best Regards

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

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.

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

Ok,no problems, glad it helped.
Best regards

List Manager

Build different lists for 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!