I have searched this forum for a simple answer and have had no luck. I know you can build table relationships. In my case, I have the following:
Table Company : Fields companyId and companyName
Table Salesperson: Fields companyRef and spName
I set relation: $crud->set_relation('companyRef','Company','companyID')
First, how can I view the companyName. And second, when I attempt to edit, I want to have a companyName dropdown but update the companyId field when done.
Please, don't send me to view set_relation topic. I have read it and it does not apply to my needs.