>I am looking for a way to generate a unique index field each time a user starts to add a record to a parent and child tables. I thought about using a SQL statement to look for the MAX on an intiger field and then adding 1, but with multiple users I feel there would be conflicts.


Hi Jeff!

Look at the Primary Key KB article on my web site.

And say hello to Rose and Larry for me.