Deriving value based on id from another table 2 Postsdj_7877 2 years ago3TopicHi,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, category12 . 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,BB3expected view for cat2cat2 | cat1AA1|AAAAA2|AAAAA3|AAABB1|BBBBB2|BBBBB3|BBBPlease let me know how to achieve that if explained in detail then it will be great help 4229 PostsKadministrator 2 years ago2Level 1You 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. 2 Postsdj_7877 2 years ago1Level 2Klas, 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 PostsKadministrator 2 years ago0Level 3Probably you cnfigured wrong storage for select field, it needs to match the coulumn where your cat1_id id is stored.