On 2 jan, 09:42, Revned wrote:
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

I think for sure you have to create that table for revisions. There
can be 2 or more revisions for each document, so.........

I don't understand why you think you need 2 subforms. What is on the
mainfrom? Maybe you can create a mainform (with document data) and one
subform (revisions).

Maybe you also could consider to split the discription field. It seems
to contain two sort of data.

Groeten,

Peter
http://access.xps350.com