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