⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Filter data from another table in grocery crud



Pandy Peril
  • profile picture
  • Member

Posted 11 September 2015 - 23:22 PM

I need to show data that filter from table_relation perangkatkeras and konfigurasi on Grocery CRUD. this both of table design.

perangkatkeras(tbl)

ID | KodeInventory | Nama
1    01-2015-aa      Switch CISCO1
2    01-2015-ab      Switch CISCO2
3    01-2015-ac      Switch CISCO3

konfigurasi(tbl)

ID | perangkatkerasID | konfigurasi
1    1                  192.90.1.1
2    2                  192.90.1.2

perangkatkerasID foreignkey from table perangkatkeras (ID-foreignkey)

I want to show the data that has not been set in the konfigurasi table in form_add(). so if i go to add konfigurasi in field perangkatkerasID only show perangkatkeras (3 - 01-2015-ac - Switch CISCO3) in dropdown form.

please help me if that case posible in grocery crud.