Multiple problems

[Verda]

when i ad a patient record it multiplies several times causing multiple records and multiple entries in the report pages which increases to 90 pages!
anyone know what is going on!? where am i going wrong!?

 

[Verda]

Thanks for your reply. What I'm trying to create is a query form with all the fields from every table (apart from a few IDs) i think want to use this query as a report so the user can print it out. Is this the correct way of going about doing things?

 

[boblarson]

Your problem appears to be that you have a query where you are trying to view one-to-many relationships and so the one side will display as many times as you have records in the many side.

What you really need is a query for the one side of the relationships and a second for the many side and the one (one side) will be the main form/report and the many side will be subforms/reports.

 

[Verda]

hey boblarson, your absolutely right there. but i'm a bit confused as to solving this problem. can you offer any further guidance?

 

[boblarson]

I don't have time at the moment as I'm at work and we're REALLY busy. But, if you don't get it before I get home tonight, I'll try to take a look and give some suggestions or samples.