infinivert

No, but thanks for clue-ing me in! That will come in handy later... --Josh

This is a stupid question, I know. But I'm honestly not sure how this works: I've got a table that has a secondary id field that will be used to link multiple records with different primary keys. I would like the secondary id to auto_increment, but I also need to override it occasionally so I can set several records to the same secondary id (this is how they will be linked). Make sense? So, can I set the field to auto_increment when I set the table up, and then manually enter values later? Nevermind. I can't have more than one auto-increment field, and it must be a key. My primary key already auto-increments, so I'll have to assign values in my PHP. Thanks anyway! --Josh