You're probably going to have to do this via code, or using a random function in an INSERT statement - I'm not aware of a DB that will create a random value automatically. If you're using Access then you might be able to use some VB code to put a random number, or even a GUID, into a field when a record is inserted.

If your DB supports stored procedures then you could probably write one of those to do it.

Any reason you can't just use an auto-increment field?

J

Because I don't even know what that means. I'm a rookie, as in, I've only been at this about three days. And now I can clarify a little bit

I need to create a form that will allow one to attach a picture, and when said person sends the form, the "whatever" will generate a "random" number. Which apparently should be a number that is in sequence with another number and only appears random (one of my friends explained it to me like that, doesn't mean I understand). Then I need a database to store said info and that will allow people to look it up when needed

I am an idiot, I freely admit that.