[TYPO3-dev] How to identify records with 2 key attributes

[Widmann, Manfred]

"Malte Jansen" <mail at maltejansen.de> schrieb im Newsbeitrag 
news:mailman.1.1197367072.4978.typo3-dev at lists.netfielders.de...
> Widmann, Manfred schrieb:
>> Hi!
>>
>> I created a  table "person" in MySQL. Key is first and last name. There 
>> is a 2nd table "results" with a foreign key relationship to person - but 
>> how to enter (in every case correct) data via the backend? The field type 
>> "Database Relation" > "Selctorbox" allows only 1 foreign key attribute 
>> and there are the guys named josef Smith and Jonathan Smith ...
>>
>> Best
>> Manfred
> Hi Manfred,
>
> you have to use the UID for it, this one of the principle of the T3. You 
> can create your Extension with the ext: Kickstarter. The rest is done 
> automatically.
>
> Cheers,
>
> Malte
Hi Malte!

Yes, I know. Maybe I didn't put things clear enough. Let me point out from a 
different angle:

When adding a record to the result table, the user has to select a 
person-record. This is done with a selector box with all the last names in 
it - but if there are duplicate last names ("Smith") he or she is not able 
to identify the right record.
I understand that TYPO3 puts all last names in the selector box because I 
have choosen last name as "label field" of "person". But how to choose last 
name plus first name ("Smith, Joe") as "label field"?

Best, Manfred