echo correct value from linked table in results page
My database structure has one main table called jobs and then a few other tables linked to jobs, for example in jobs there is a client_id field which is an integer, I then have a clients table with a unique id of client_id and it lists the client names etc. this all works fine and I have made all of the correct bindings when setting up my drop-down menus in my insert and update pages.
what I am stuck on is outputting the correct value in the results field, right now it outputs the integer and I would like it to output the corresponding value from the clients table.
any help with this would be greatly appreciated
Cheers
Pete