Relationships

5,864 topics in this forum

1. Table Relationships and Value Lists?

   By Tony Diaz, June 26
   • 6 replies
   • 485 views
   • 
   • Wim Decorte
   • June 28

2. How to structure, would this be Many-to-Many?

   By Tony Diaz, June 20   

   • relationships
   • many-to-many
   • (and 2 more)

     Tagged with:

     • relationships
     • many-to-many
     • value list
     • portal
   • 3 replies
   • 574 views
   • 
   • comment
   • June 20

3. In a relationship table, is it ok to use two foreign key of a combination ID to connect to each other?

   By Spidey, June 16
   • 0 replies
   • 683 views
   • 
   • Spidey
   • June 16

4. Determine safety of deleting table occurrence

   By Pumpkin_Escobar, June 2
   • 3 replies
   • 896 views
   • 
   • Fitch
   • June 7

5. What is the 'Good Way' to Do a Relationship ... and Avoid Duplicate Entries?

   By Tony Diaz, June 3
   • 11 replies
   • 974 views
   • 
   • bcooney
   • June 6

6. Retrieve Data From Crosstab Table

   By Spidey, June 1
   • 1 reply
   • 858 views
   • 
   • Ocean West
   • June 1

7. many to many relationship between 2 occurrences of the same table via a join table

   By Philem63, June 1
   • 1 reply
   • 944 views
   • 
   • Ocean West
   • June 1

8. Changing the match field in a relationship (without breaking anything)

   By Angus McKinnon, May 8
   • 3 replies
   • 1.4k views
   • 
   • Angus McKinnon
   • May 22

9. Merging duplicates with child records

   By Matt.C, May 18
   • 0 replies
   • 1.3k views
   • 
   • Matt.C
   • May 18

10. Find Field via Relationship

    By sirsancho09, May 13
    • 6 replies
    • 1.4k views
    • 
    • sirsancho09
    • May 14

11. Get count of related records with specific field value

    By BrainlessBlock, May 7   

    • relationships
    • 1 reply
    • 1.4k views
    • 
    • comment
    • May 7

12. Display Related Field In Subsummary Part

    By Jay86, May 4   

    • related field
    • subsummary
    • (and 1 more)

      Tagged with:

      • related field
      • subsummary
      • lookup values
    • 3 replies
    • 1.4k views
    • 
    • Jay86
    • May 4

13. Multi Criteria Relationship Not Working

    By tiffany, April 30
    • 3 replies
    • 1.3k views
    • 
    • bcooney
    • April 30

14. Help with multiple relational paths

    By apinrise, April 23
    • 3 replies
    • 1.4k views
    • 
    • Ocean West
    • April 23

15. Failing relationship

    By aiharris, April 9
    • 1 reply
    • 1.5k views
    • 
    • comment
    • April 9

16. Portal Records Display

    By Paul Hunt, April 1
    • 4 replies
    • 1.5k views
    • 
    • Paul Hunt
    • April 8

17. Scout Database

    By lewisandrea, March 14
    • 11 replies
    • 1.6k views
    • 
    • comment
    • March 14

18. Schema advice, please

    By WF7A, March 10
    • 1 reply
    • 1.3k views
    • 
    • Ocean West
    • March 10

19. Users photos vs Default photos "toggle" - how?

    By Tony Martin, February 29
    • 2 replies
    • 1.3k views
    • 
    • Tony Martin
    • March 10

20. Help with Project ID's

    By extreme, February 29
    • 2 replies
    • 1.3k views
    • 
    • comment
    • March 10

21. Portal showing sub-summaries

    By trvr, March 10   

    • Summary Data
    • filter portal table
    • 1 reply
    • 1.2k views
    • 
    • comment
    • March 10

22. Filemaker 16 Auction calendar with users' data HELP

    By Tony Martin, March 7   

    • relationships and portals
    • 1 reply
    • 1.1k views
    • 
    • Fitch
    • March 8

23. Multiple Drop Down Lists

    By Muz Riz, March 5
    • 2 replies
    • 1.2k views
    • 
    • Muz Riz
    • March 5

24. how to lookup value from get summary in related table

    By Wahyu, January 29
    • 0 replies
    • 1.1k views
    • 
    • Wahyu
    • January 29

25. Beginner looking for guidance w ER chart (pic inside)

    By ldeikis, December 4, 2019
    • 4 replies
    • 1.4k views
    • 
    • comment
    • December 5, 2019

26. Key relationship through dropdown best practice?

    By bac mac, November 22, 2019
    • 2 replies
    • 920 views
    • 
    • bac mac
    • November 23, 2019

27. Table Lookup

    By Salesman0Gil, November 13, 2019
    • 12 replies
    • 823 views
    • 
    • Salesman0Gil
    • November 20, 2019

28. Next lowest within list

    By neilticktin, October 28, 2019
    • 1 reply
    • 791 views
    • 
    • comment
    • October 28, 2019

29. Help for Newbie

    By Adam Robert, October 11, 2019
    • 2 replies
    • 685 views
    • 
    • rwoods
    • October 14, 2019

30. Populate/Update child record's date field based on parent relationships

    By ehwalker, September 9, 2019
    • 6 replies
    • 1k views
    • 
    • ehwalker
    • September 10, 2019

31. Filtered Portal Problem

    By Greg58, August 3, 2019
    • 2 replies
    • 661 views
    • 
    • Greg58
    • August 5, 2019

32. Track health indicators

    By andersmnystrom, June 11, 2019
    • 20 replies
    • 883 views
    • 
    • andersmnystrom
    • August 1, 2019

33. Need help with portal

    By Gilbert13, July 26, 2019
    • 2 replies
    • 327 views
    • 
    • Gilbert13
    • July 26, 2019

34. How to list multiple selected Records into a Table View List

    By CoreyS, July 23, 2019
    • 3 replies
    • 263 views
    • 
    • comment
    • July 24, 2019

35. Field contents are duplicating

    By Greg58, March 6, 2019
    • 8 replies
    • 660 views
    • 
    • Greg58
    • July 19, 2019