>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.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer