Hello to everyone.
I created those class

class ProductorManager extends Page
{
static $db = array('Percentage'=>'float'
);
static $has_one = array('id_productor'=>'Member'
);

public function Productors()
{
return DataObject::get("ProductorManager ");
}
}

class ProductorManager _Controller extends Page_Controller
{
}

and i've the table setted up, but i cannot retrieve datas from them. i thinks function Productors() is correct, but something don't work.
I want to show Percentage and the complete productor's name fetched by Member's tables

I dont know if i want clear about the explaination.
Thanks to everyone.

VG

you probably want to put that function in the Page_Controller, for starters.

what does your template code look like?

Template page look like in this way temporarily

<div class="body">
<h1>$Title</h1>
<% include SideBar %>
<div style="clear:left">

<% if Productor %>
<% control Productor %>
$FirstName .<br />
<% end_control %>
<% else %>
<div class="message">No productors found</div>
<% end_if %>
</div>
</div>

First I put Productors() inside the Controller Class, but didn't work.
I want to show each productor's name and i don't know where i've made a mistake.

thank you very much

I solved that problem using a DataObject-derivated class.

class Produttori extends DataObject
{
static $db = array('Percentuale'=>'float');
static $has_one = array('Produttore'=>'Member');
}

Thanks you