A question about previewing reports

[foody]

This is the scenario I am in:

NewClient have one to many relationship with estimate. There is one new client for as many estimates. The new client table holds information of the client, name, address and so on, the estimate table ONLY holds information about the estimate, what evre the case be. I want to be able to when I go to preview report, that it displays the address information of that newclient with the information of th estimate..but if that new client have say 30 estimates, I want to be able to view the selected estimate of that new client. Does anyone know how to do that? I know it has to do with the macro and select where, but I don't know how to do it myself.

This is the important information you need to know about the estimate and new client:

Estimate table:

EstimateID
CustomerNumber
....

NewClient table:

ClientID
Full Name
CustomerNumber
.....

Any suggestions would be greatly appreciate it. Thanks in advance.

 

[Rovers]

If you mean that 1 of the 30 estimates is the one selected by the client then you need to record that in your estimates table.

For example you need a field of type boolean (I suggest) that records 1 or 0.

It will be "1" for the record (estimate) that the client selects.

_

In the query that drives the report you will return those records with "1" in that field. This will return what you want.

To do this: in the criteria row just type "1"

 

[foody]

No you misunderstood me Rovers and I am always afraid that this might happen.

OK here let me do it in a better scenario, this is how the report is chunked into pieces.


(A) Bill To
Fahed Al Daye
3340 Du Parc Ave, APT 120
Montreal, Quebec, Canada
H2Z 3R4

Job To
Ahmed Al Daye
3340 Du Parc Ave, APT 1230
Montreal, Quebec, Canada
H2Z 3R4

Job Number (B)
J-41234

Description
Test

TaxID
12293948485

(A) This comes from the New Client Table
(B) This comes from the Estimate table

Now say I want to create another estimate with the same client, I would be able to do that in the form NewClient which would be the parent that holds the information on (A), and the subform would be the estimate, the holds the information on (B). With the estimate (subform) I can click on the next button and create another estimate and another and another and another all with the same information still on (A). Until I create a new client with their own set of estimates. My actual question is, if I want to the first client with the first estimate I want to be able to click print preview and show what is described above, UNLESS I click next estimate and then click Print Preview I would still have the information on (A) been the same because I have not clicked NEXT on the newclient, I only clicked NEXT on the estimate, but the information on (B) would change instead.

So how do you do that when I click on Print Preview? I know it have to do with a certain macro code but I don't know what that code is, any idea would be greatly appreciate it.

 

[foody]

Please any help would be greatly appreciate it!!?