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.