On my old selling site when an order was completed the data is put into a serialized array. On the ‘new client’ page of the admin site I have a drop down of the clients who have completed an order.

Database views consist of a stored query accessible as a virtual table composed of the result set of the query. Views are dynamic in that if you change data it tables that are part of the views query, then the data shown in subsequent invocations of the view will change. Views are used to join [...]

The Kohana controller is what will control what happens between the models and the views in an application, MVC (model view controller).