5 years ago
3
Topic

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

Get a VIP membership
4229 Posts
Kadministrator
5 years ago
2
Level 1

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.

5 years ago
1
Level 2

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.

4229 Posts
Kadministrator
5 years ago
0
Level 3

Probably you cnfigured wrong storage for select field, it needs to match the coulumn where your cat1_id id is stored.

Get a Book for SEBLOD