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