[joeinatlanta]

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.  

 

Joe

 

 

[joeinatlanta]

Sooo, I found the answer to my own question.  I guess my only question would be, when you set the relation you specify your foreign key and your parent table.  How does it know which field to use as the primary key?  Joe