>This post is dealing with my earlier post.
>
>I have a document with a number, revision, and submittal number. This is one table.
>
>A second table holds document items belonging to the documents in the first table.
>
>If I want a one table to many table relation, would it be better to have a field that holds a unique index of the particular document, than to index on the doc, rev, sub no comination.

I M O an auto inc'ing s'gate key would be better than the d, r, s # combo. R U sure that you "want a one table to many table relation" most people have one-to-many rows?