Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

multi relationships

Discussion in 'Information Technology' started by yaniv d, Jul 28, 2006.

  1. yaniv d

    yaniv d
    Expand Collapse
    Guest

    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?
     
  2. Loading...

    Similar Threads Forum Date
    Opinion Youth of Punjab facing multiple challenges: Dal Khalsa chief Punjab, Punjabi, Punjabiyat Mar 22, 2013
    Grammer / Vyakarn Fateh multimedia forced to close for lack of funds Language, Arts & Culture Nov 21, 2012
    Multicultural Minstrel - Sikh-Aussie Dya Singh Gurmat Sangeet Nov 13, 2011
    Canada Happy Birthday to Canadian Multiculturalism Breaking News Oct 9, 2011
    Controversial Does Racialized Media Harm Multiculturalism? Hard Talk Aug 17, 2011

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    yaniv d wrote:
    > 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?

    --
    Joseph Meehan

    Dia duit
     
  4. yaniv d

    yaniv d
    Expand Collapse
    Guest

    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
     
  5. yaniv d

    yaniv d
    Expand Collapse
    Guest

    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
     
  6. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    yaniv d wrote:
    > 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?

    --
    Joseph Meehan

    Dia duit
     
  7. yaniv d

    yaniv d
    Expand Collapse
    Guest

    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
     
  8. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    yaniv d wrote:
    > 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.

    --
    Joseph Meehan

    Dia duit
     

Share This Page