Relationships

5,876 topics in this forum

1. Need Help with Relationship

   By Jennifer, November 12
   • 2 replies
   • 46 views
   • 
   • Jennifer
   • November 12

2. Inventory database - sensible table structure

   By Angus McKinnon, October 25
   • 2 replies
   • 67 views
   • 
   • bcooney
   • November 5

3. Conditional Value List

   By Tracy, October 31
   • 4 replies
   • 71 views
   • 
   • Tracy
   • November 2

4. How to get data from one table to use in another when the tables don't really need to be related.

   By JMW, July 21   

   • relationship problem
   • 6 replies
   • 220 views
   • 
   • JMW
   • September 16

5. Relationships and portals

   By Chrism, September 11
   • 3 replies
   • 65 views
   • 
   • Chrism
   • September 11

6. Portal displaying conditional values based on selection and current user

   By McScripta, September 1
   • 3 replies
   • 99 views
   • 
   • McScripta
   • September 2

7. Append in field vs. Details table

   By Idahomail, September 1
   • 0 replies
   • 70 views
   • 
   • Idahomail
   • September 1

8. Relationship across 2 TOC's

   By Greg58, August 28
   • 4 replies
   • 68 views
   • 
   • Greg58
   • August 31

9. Managing cross references - permuting and commuting

   By DZ3, August 8
   • 2 replies
   • 68 views
   • 
   • DZ3
   • August 9

10. Custom order appears to have been lost

    By jjjjp, August 6
    • 6 replies
    • 107 views
    • 
    • jjjjp
    • August 7

11. Scheme for an editorial flow - Recommendations

    By Mauriki, August 7
    • 1 reply
    • 77 views
    • 
    • comment
    • August 7

12. What is a good schema to represent keystones in 3 space?

    By Danxyz, July 14
    • 6 replies
    • 191 views
    • 
    • comment
    • July 14

13. Table Relationships and Value Lists?

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

14. 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
    • 922 views
    • 
    • comment
    • June 20

15. 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
    • 960 views
    • 
    • Spidey
    • June 16

16. Determine safety of deleting table occurrence

    By Pumpkin_Escobar, June 2
    • 3 replies
    • 1.2k views
    • 
    • Fitch
    • June 7

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

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

18. Retrieve Data From Crosstab Table

    By Spidey, June 1
    • 1 reply
    • 1.1k views
    • 
    • Ocean West
    • June 1

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

    By Philem63, June 1
    • 1 reply
    • 1.3k views
    • 
    • Ocean West
    • June 1

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

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

21. Merging duplicates with child records

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

22. Find Field via Relationship

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

23. Get count of related records with specific field value

    By BrainlessBlock, May 7   

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

24. 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.7k views
    • 
    • Jay86
    • May 4

25. Multi Criteria Relationship Not Working

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

26. Help with multiple relational paths

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

27. Failing relationship

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

28. Portal Records Display

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

29. Scout Database

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

30. Schema advice, please

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

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

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

32. Help with Project ID's

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

33. Portal showing sub-summaries

    By trvr, March 10   

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

34. Filemaker 16 Auction calendar with users' data HELP

    By Tony Martin, March 7   

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

35. Multiple Drop Down Lists

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