How to use a relation fields - Cobalt 8

mocka
Total posts: 3
25 Янв 2015 21:34

I have, for example, two tables: 1. cars with fields id, car_name 2. models with fields id, car_id, model_name

I want to use two combo-boxes to gather inputs. In first combo-box I want to have cars name and into the second I want to have model names filtered by car_id.

It's possible to do it?

Последние изменения: 29 Янв 2015

Цитата

Sergey

Total posts: 13,748
26 Янв 2015 05:19

Please, whatch this video.

Цитата

mocka
Total posts: 3
26 Янв 2015 07:55

Thank you Sergey, for your's quick reply. I saw the video but, unfortunately, it present the possibility to put in relation two (or more) articles. I wander if it is possibly to put in relation two fields which belong to the same article. May be, could I referer to the value that was selected into a select field type? Something like this (sql sources for the second select field type - models): select 'id' as id, 'model_name' as text from 'models' where 'models.car_id' = cars_field.value where cars_field.value is the value that was selected into the first select field type

Цитата

Sergey

Total posts: 13,748
26 Янв 2015 10:47

You need to use Multiple Level Select Field.

This fields allows create tree like structures. You chose first level, then second level appear.

Цитата

mocka
Total posts: 3
27 Янв 2015 09:42

Thank you very much. Exactly what I need. Now, I have another challenge. How can I generate the import file using my tables?

Цитата

Sergey

Total posts: 13,748
29 Янв 2015 08:58

Import is limited in Cobalt. Not all fields support import and only specific formats of text suported like select calues as strings separated by coma.

Работает на Cobalt