Report design

[sturdytenor]

I have a database of drawing details. Table 1 contains Drawing no., project, title etc, and Table 2 contains revision details for each drawing (0,A,B,C.....K). Table 2 is updated via a Form and subform. The two tables are linked by a query using drawing number as a relationship. I have created a report which displays drawing details and current revisions. I want to modify the report so that it displays all revision references (0,A,B.....K) even if the details are not yet entered in the 2nd table. I want the report to display blank boxes so that details can be temporarily pencilled in pending update.

Thanks in advance.

 

[Fornatian]

What you will need to do is change the join relationship in the query window so that it shows ALL records from one side and only records from the sub table where there is a matching ID. After doing that run the query and you should get a list of your primary info with gaps where data is "missing", for want of a better word.

Now run the report and you should see gaps where the data is required.

Best thing to do is put a border on the appropriately required boxes so the reader knows where to pencil the detail into.

Hope thsi helps

Ian