DEMO SITE v1.7.20

Simple relation Bootstrap 4.5 theme

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 
1AnthonywdxNYC View Edit Remove
2LeslieJenningsfSan Francisco View Edit Remove
3JulieettekFirrelliSydney View Edit Remove
4StevePatterson View Edit Remove
5Foon YueTseng View Edit Remove
6LouiBondurParis View Edit Remove
7GerardHernandezParis View Edit Remove
8PamelaCastilloParis View Edit Remove
9LarryBottLondon View Edit Remove
10BarryJonesLondon View Edit Remove
Search