In the products table they are a number in a column which is converted to a name in another table named productmanufacturers. I don't know if that was what you were looking for.
I'll check out those other threads.
*Edit. So how would the innerjoin look like in the recordset?