Thanks for the help. I'll see Larry and Rose next month in our meeting.

>>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.