double primary/unique, how to autoincrement one based on the other.

[kplex]

Sorry if the title of this post is a bit confusing as that what I am, confused.

I have the following situation

|EventID  |ComponentID | Description |
#---------#------------#-------------#
|1        |1           | blah        |
|1        |2           | de          |
|2        |1           | blah        |

I have a list of events which are broken into those generated by different components. The EventID is unique for each component (I have these generated as unique and primary).

Now what I want to be able to do is add a new event, I want the page to display the number of the event being added (ie the next number in the autoincrement). This has to take into the account of the ComponentID, that is (based on the table above) if I were to add a Component 1 event it would have EventId 3 but if I were to add a Component 2 event it would have EventId 2..

I'm not sure how to implement this as I'm a total Database novice.. if all else fails I'm tempted to have a table for each component but this would make adding new Components messy.

Any help greatly appreciated.
/John

[kplex]

Hey I've taken the crazy step of reading the manual...

3.5.9 Using AUTO_INCREMENT
...
For MyISAM and BDB tables you can specify AUTO_INCREMENT on secondary column in a multi-column key. In this case the generated value for the autoincrement column is calculated as MAX(auto_increment_column)+1) WHERE prefix=given-prefix. This is useful when you want to put data into ordered groups.
....

Doh !!!!

Sorry for the stupid question guys.
/John