Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Posts
    1

    Question Unanswered: many to many relationships

    first, apologies - i'm doing some work for a non-profit and they're still using FMP 4.0, so those of you in the 6.0 world may run into some unpleasant memories here.

    so, is there a "standard" way to do many to many relationships?

    i come from an SQL background, and feel like a many to many relationship shouldn't be too hard with filemaker. i've read it's unsupported for 4.0 but there's gotta be a way.

    everything i've found involves relationships based on calculated fields that equal "1", a lot of code, or something else that seems a little weird, or "magical".

    i guess i'd be ok with these solutions if someone explained what those relationships and code do. i'm still having a bit of trouble picturing how this will all be intuitive to a user. any suggestions much appreciated.

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320

    Re: many to many relationships

    Originally posted by jlevine
    first, apologies - i'm doing some work for a non-profit and they're still using FMP 4.0, so those of you in the 6.0 world may run into some unpleasant memories here.

    so, is there a "standard" way to do many to many relationships?

    i come from an SQL background, and feel like a many to many relationship shouldn't be too hard with filemaker. i've read it's unsupported for 4.0 but there's gotta be a way.

    everything i've found involves relationships based on calculated fields that equal "1", a lot of code, or something else that seems a little weird, or "magical".

    i guess i'd be ok with these solutions if someone explained what those relationships and code do. i'm still having a bit of trouble picturing how this will all be intuitive to a user. any suggestions much appreciated.
    To make many to many table relation in fmp you will need 3 fmp db

    A, a_to_b, and b for example.

    a_to_b is in relation with A and B

    So you can insert calculted fields in a_to_b that read related data from a and b so in A by relation you can read data from B in A.

    Your a_to_b db look like

    id
    ref_a
    ref_b
    data1_froma calcul
    data2_froma calcul
    data1_fromb calcul
    data2_fromb calcul
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Apr 2004
    Posts
    5
    Is there another way of getting information for table A without using calculation fields in FMP 6?

  4. #4
    Join Date
    Mar 2004
    Location
    Pittsburgh, PA
    Posts
    13
    Originally posted by Joker2k_2003
    Is there another way of getting information for table A without using calculation fields in FMP 6?
    No. You need calc fields in a_to_b.

    However, it IS possible to do this without calc fields in FM7. The relationship structure has been changed to make it much easier to do one-off relationships; if A is related to A_to_B, which is related to B, B can draw data directly from A.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •