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
1AntFraParis View Edit Remove
2LeslieJenningsNYC View Edit Remove
3LeslieThompsonLondon View Edit Remove
4JulieFirrelliParis View Edit Remove
5StevePattersonBoston View Edit Remove
6Foon YueTsengchuNYC View Edit Remove
7GeorgeVanaufNYC View Edit Remove
8LouiBondurParis View Edit Remove
9GerardHernandezParis View Edit Remove
10PamelaCastilloParis View Edit Remove
Search