Hey,
I'm trying to join two tables now for hours but it seems I'm just to stupid ...
I found a lot of threads to this question here on the board, but I do not get it to run.
Table1: [fahrer]
Columns: [id], [name], [nickname]
Table2: [score]
Columns: [id], [fahrer_id], [race], [timescore],
The columns [fahrer].[id] and [score].[fahrer_id] should be joined.
When displaying I'd like to have the [fahrer_id] displayed.
When adding/editing I'd like to have the [name] as a dropdown field to set the [fahrer_id].
Could anybody give me the correct syntax ?
Is there a wizard for joining tables, like there is for a single table (phpMyEditSetup.php) ?
Thanks in advance !
|