multi relationships

[yaniv d]

hello all,
i build a query that have 2 tables that are conected to most of the
records in the 2 tables.
when i'm loading report everything ok ,but when i'm loading a form
everything is very heavy and there is alot of "running query" and the
form is working very slow.in order for me to make the form rum in a
usual way i need to cut almost all the relationships but it give me
wrong calculated numbers.
does someone bump into this problem and fimd a solution to it?

 

[Joseph Meehan]

hello all,
i build a query that have 2 tables that are conected to most of the
records in the 2 tables.
when i'm loading report everything ok ,but when i'm loading a form
everything is very heavy and there is alot of "running query" and the
form is working very slow.in order for me to make the form rum in a
usual way i need to cut almost all the relationships but it give me
wrong calculated numbers.
does someone bump into this problem and fimd a solution to it?

How about a little more detail, especially the table structure,
relationships and number of records?

 

[yaniv d]

i have a sum query that built on 2 tables that are conected to each
other,there is around 15 records connected one to each other,its too
much of a load for the form.
i would like to send you a picture of this query so you will have more
understanding if this didnt help

 

[yaniv d]

i have a sum query that built on 2 tables that are conected to each
other,there is around 15 records connected one to each other,its too
much of a load for the form.
i would like to send you a picture of this query so you will have more
understanding if this didnt help

 

[Joseph Meehan]

i have a sum query that built on 2 tables that are conected to each
other,there is around 15 records connected one to each other,its too
much of a load for the form.
i would like to send you a picture of this query so you will have more
understanding if this didnt help

I little more detail please. How are the related? What field(s) in
each table is related to the other? What table(s) has the numbers that are
the source of the calculations?

What is the relationship(s)? 1-many or many to many or what?

 

[yaniv d]

its connected many to many,the join properties is on (1)-only include
rows where the joined fields from both table are equel.

there are 3 tables,2 tables that connected to another for the
match(thats why most of the record there are connected) and 1 table
that is not connected to the many to many table that have only 1 record
connected to 1 of the tables and these are used for calculation.
so you have 2 tables that have numbers for calcutaion and 1 that is
just searching for a match for 1 of the table

 

[Joseph Meehan]

its connected many to many,the join properties is on (1)-only include
rows where the joined fields from both table are equel.

there are 3 tables,2 tables that connected to another for the
match(thats why most of the record there are connected) and 1 table
that is not connected to the many to many table that have only 1
record connected to 1 of the tables and these are used for
calculation.
so you have 2 tables that have numbers for calcutaion and 1 that is
just searching for a match for 1 of the table

I believe your problem is due to the many to many relationship.

Could you provide some additional detail about the tables involved and
the relationships between the tables.