Simple relation

You can get options list from other table

HIDE CODE
<?php
	$xcrud = Xcrud::get_instance();
    $xcrud->table('employees');
    $xcrud->table_name('Simple relation');
    $xcrud->relation('officeCode','offices','officeCode','city');
    $xcrud->label('officeCode','Office in');
    $xcrud->columns('firstName,lastName,officeCode');
    $xcrud->fields('firstName,lastName,officeCode');
    $xcrud->limit(10);
    echo $xcrud->render();
?>

Simple relation

#FirstnameLastnameOffice in
Actions
1MartinmGerardParis View Edit Remove
2 View Edit Remove
3bertheazertSan Francisco View Edit Remove
4pippo.dadmkmkma3432432kjkjkjkSydney View Edit Remove
5 View Edit Remove
6 View Edit Remove
7Sevilla View Edit Remove
8HerreraFaustoSevilla View Edit Remove
9FaustoHerreraLondon View Edit Remove
10 View Edit Remove
Search