[TYPO3]  TCA MM_match_fields custom value problem
    Gijs Epping 
    gijs.epping at efocus.nl
       
    Thu Mar 20 18:44:05 CET 2008
    
    
  
Hello,
I wil try to explain this problem as good as i can becuase its's a bit 
complex.
I have two tables that are connected by a MM table.
tableA
----id
----title
----companyname
----season_id (int)
tableB
----id
----clientname
----clientnumber
And a mm table
ext_new_tableA_tableB
----uid_local
----uid_foreign
----sorting
----season_id (int)
This is a piece of the TCA from company (tableA)
	"exclude" => 1,		
	"label" => "Company",		
	"config" => Array (
	"type" => "select",	
	"internal_type" => "db",	
	"allowed" => "ext_new_tableB",	
	'foreign_table' => 'ext_new_tableB',
	"size" => 10,	
	"minitems" => 0,
	"maxitems" => 100,	
	"MM" => "ext_new_tableA_tableB",
	"MM_match_fields"=>array("season_id"=>"needseasonidfromtableA"),
Is it possible to insert the season_id from tableA in the mm table in 
the TCA or a other way? i need this for a frontend query because i need 
to find for example all the clients in a company with season_id 20.
I hope it is making some sense if not let me know.
Regards Gijs
				
	
	
    
    
More information about the TYPO3-english
mailing list