Hi,

It's nice to be back here!!

I am planning to make a database for Engineering Documentation
I have the following fields

tblDocumentList
Document No Client No Description
12345 0789 Civil Works - Bldg Foundation
67890 0891 Civil Works - Steel Structure

Now each document may sometimes consist of more than one revision
I want that in my Form to have a two subform one is to view the list of
documents
the second one would be the list of revisions of a selected documents. How
can I set up my table? Do I need to create another table let say
(tblRevision) for the list of revision?

thanks anyway..Happy New Year