Hi folks, I imagine a good search would help me find the answer to my problem, but unfortunately, I don't know the words to use to describe my problem. So, I'll describe it here and seek either the terminology I need to learn more or possibly the solution.
I'm completely new to CakePHP but somewhat familiar with PHP and MySQL. Familiar enough with the later, that I've decided I need to first to make a better application. Imagine I have the following database tables. TABLE job_title id desc level TABLE job_levels id desc A record in the job_title table would look something like: id = 1 desc = CakePHP Developer level = 3 And the job_levels table has the following data id = 3 desc = Senior So, in this case, when I do a join in MySQL, I'd get a job_title record that looks something like: id = 1 desc = CakePHP Developer level = 3 desc = Senior Basically, I'm substituting the job level id for the job level desc. Now, how do I do the same in CakePHP? I built put an association in the model for Job but that doesn't return exactly what I want. Essentially, for each job, I'd like to have the level description available in the model. At least I think this is what I want. Maybe there is some concept I'm missing that would make this unnecessary. Hopefully this makes sense. Any help or advice is greatly appreciated. robbie -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php