I really need to implement 1-1 relation between two tables. These are my tables:
Users: id, username, email, password
Userinfo: id, Isers_id, firstname ,lastname, mobile, address, ...
The users table is read only... This is a suggested solution:
->set_table('Userinfo') ->columns('users_id','users_id'); ->set_relation('users_id','Users','username') ->set_relation('users_id','Users','email')
But the problem is that I cannot set two 'users_id' columns!!!
What do you suggest?