client table is:
client_userid fk to userid in users table which has in that table:
it is inserting it into the database correctly. as in i have a user who has a userid = 2
when he logs in and adds a case it adds it into the mysql database as:
that is working fine but in the details page i created with data assist it shows the client_userid as 2 but i want to change this to a more user friendly name so the field is "assigned to" and i want the 2 to be the username.
how can i change this?