>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.
The most common method is make a shared table with a counter field in it for each table that has an integer key.
--Todd Sherman
-Wake Up! Smell the Coffee!