Hi,
I am new to SEBLOD and facing following issue. I have two tabled linked with 2 forms
1 . josbw_cck_store_form_cat1 just two columns id, category1
2 . josbw_cck_store_form_cat2 just three columns id, category2, cat1_id (from %cck_store_form_cat1 table)
while creating view for cat2 I want cat1 name based on cat1_id stored in cat2 table.
cat1 table has 2 values AAA, BBB
cat2 table has 6 values AA1,AA2,AA3,BB1,BB2,BB3
expected view for cat2
cat2 | cat1
AA1|AAA
AA2|AAA
AA3|AAA
BB1|BBB
BB2|BBB
BB3|BBB
Please let me know how to achieve that if explained in detail then it will be great help
You can get values from related table in various ways e.g. using SQL field or by using select dynamic - just usecat1 table to create select's values and texts.
Klas, Thank for your prompt response.
I have already created dynamic field on cat2 form to show cat1 as list of values and to pull id but when I use that field in my list view its not working.
Probably you cnfigured wrong storage for select field, it needs to match the coulumn where your cat1_id id is stored.