Report not showing properly

[ashu.doc]

Hi
I have created report based on a query, basically in my application there may be multiple users using their own set of datas. So it is something like this -

1 Surgeon - many patients- each patient had some surgery

So my report is based on a query which include some fields from surgeon details at the page header and details secion showing list of patients and their operation details, since my application has option for multiple surgeons adding their own patient list and operation, what I wanted was that this report to show each surgeon's own record only, but what is happening, it is showing all the records as one list and the name and detail of the last surgeon added on the Page header.



(Also just to let you know the Surgeon details is the main form and patient detail is as a subform, when I am opening one surgeon's details it is showing only that surgeon's patients in the form and not the other surgeon's patients, so I think the relationships are working fine.)

[rpeare]

It sounds like you don't have your form/subform links defined correctly

If your main form is the surgeon and your first subform is the patients related to that surgeon you have to create a link through your primary key between the form and subform

Similarly you'd have to establish a link between the patient and their surgeries between the subform and the sub-subform. If you don't establish this secondary link it will show you all surgeries from everyone.

[ashu.doc]

Hi
I dont how to relate form and subform, I know how to make relationship for tables and as I said main form and subform are working fine together because when I change the surgeon's name in main form, the patient details for that surgeon is coming up fine and that patient detail is a subform to maiin form.

[ashu.doc]

What I feel that there may be something in the query for that report where I have to do some changes to bring surgeon specific report..does that make any sense?

[rpeare]

a form/subform works the same way a report/subreport works, your original post was about a report, if you set up your report with the same link definitions your form does you'll be fine assuming your form is showing you everything correctly.

[ashu.doc]

yes it is showing correctly in the report now when I have re done a report with the same query, but what I was doing before was that I was putting the surgeon details in page header by moving the fields from the detail section, if I dont do that now what is happening the report is sorting out the surgeon and their patient fine but still it is showing all the surgeons in the same report.
what I want is that when I open the particular form and subform for a surgeon and click on the button for report it only opens that surgeon's patient list, but since I have created one report as all together it is not happening.

[ashu.doc]

Seems that it is not possible what I am trying to do, so I have to take off the option for multiple users to use this application and only allowing single user to use the application.

[rpeare]

I don't understand your post, but I understand your intent. If you can supply a sample copy of your database it would be much easier to advise you when we're having a communication issue.