I am using CakePHP, this is actually the structure of my DB:


CarMakes

----------------------------------

ID     Slug     Title

16     ford     Ford

CarModels

----------------------------------

ID     Title     CarMake_ID

10     Escort   16

Cars

----------------------------------

ID     Title     CarModel_ID

1      My vehicle   10

I wish to view a listing of cars by CarMakes.Slug

therefore the url could be: http://localhost/cars/ford

Any ideas or general directions of knowledge?

You should use [cde] or [cde] to retrieve records according to something apart from ID. If you want to supply conditions towards the query, use regular [cde]:

findBy()

Also, for that URL you are trying to setup, you will have to produce a route for findAllBy():

find()

Edit:

The above mentioned works in case your conditions derive from an immediate association in your model. In case your the weather is on the recursive association (i.e. Vehicle->CarModel->CarMake), you should utilize explicit joins:

$this->Car->find(
   'all',
   array(
      'conditions' => array(
         'CarMake.Slug' => $slug,
         'Car.Name LIKE' => $name
      ),
   )
);