[eluser]jedd[/eluser]
[quote author="rijobo" date="1260991800"]
I've got a table product where i for example use materiaal_id. This is the id from the table materiaal. I would like to use the field name of that table.
[/quote]
You need to do this in your model - when you retrieve the data from
product. You are likely going to have to do a
JOIN here, connecting product to materiaal.
I suggest you first go and read about JOINs in the MySQL documentation (assuming you're using MySQL here).
Then read about ->join functions in the [url="/user_guide/database/active_record.html"]AR section of the CI User Guide[/url]. You haven't shown your database query at all, so it's not clear if you're using AR or vanilla SQL. Both are straightforward, however.
Try doing your queries first at a database / SQL command line so that you understand what's happening, and then within PHP use the print_r() or var_dump() functions to see the nature of the data you get back from these calls.