hi eric,
client table is:
clientid
firstname
lastname
dateofbirth
client_userid fk to userid in users table which has in that table:
userid
username
firstname
lastname
email
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:
clientid=1
firstname=joe
lastname=bloggs
dateofbirth=01/01/1983
client_userid=2
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?
thanks