Relationships

5,945 topics in this forum

1. How to use "allow creation of records"...and "delete related records in this table"...in the left side in the edit relationship

   By Spidey, December 4, 2020
   • 2 replies
   • 405 views
   • 
   • Spidey
   • December 6, 2020

2. Need Help with Relationship

   By Jennifer, November 12, 2020
   • 2 replies
   • 447 views
   • 
   • Jennifer
   • November 12, 2020

3. Conditional Value List

   By Tracy, October 31, 2020
   • 4 replies
   • 503 views
   • 
   • Tracy
   • November 2, 2020

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, 2020   

   • relationship problem
   • 6 replies
   • 844 views
   • 
   • JMW
   • September 16, 2020

5. Relationships and portals

   By Chrism, September 11, 2020
   • 3 replies
   • 395 views
   • 
   • Chrism
   • September 11, 2020

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

   By McScripta, September 1, 2020
   • 3 replies
   • 489 views
   • 
   • McScripta
   • September 2, 2020

7. Append in field vs. Details table

   By Idahomail, September 1, 2020
   • 0 replies
   • 402 views
   • 
   • Idahomail
   • September 1, 2020

8. Relationship across 2 TOC's

   By Greg58, August 28, 2020
   • 4 replies
   • 417 views
   • 
   • Greg58
   • August 31, 2020

9. Managing cross references - permuting and commuting

   By DZ3, August 8, 2020
   • 2 replies
   • 366 views
   • 
   • DZ3
   • August 9, 2020

10. Custom order appears to have been lost

    By jjjjp, August 6, 2020
    • 6 replies
    • 489 views
    • 
    • jjjjp
    • August 7, 2020

11. Scheme for an editorial flow - Recommendations

    By Mauriki, August 7, 2020
    • 1 reply
    • 397 views
    • 
    • comment
    • August 7, 2020

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

    By Danxyz, July 14, 2020
    • 6 replies
    • 540 views
    • 
    • comment
    • July 14, 2020

13. Table Relationships and Value Lists?

    By Tony Diaz, June 26, 2020
    • 6 replies
    • 1.2k views
    • 
    • Wim Decorte
    • June 28, 2020

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

    By Tony Diaz, June 20, 2020   

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

       Tagged with:

      • relationships
      • many-to-many
      • value list
      • portal
    • 3 replies
    • 1.6k views
    • 
    • comment
    • June 20, 2020

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, 2020
    • 0 replies
    • 1.3k views
    • 
    • Spidey
    • June 16, 2020

16. Determine safety of deleting table occurrence

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

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

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

18. Retrieve Data From Crosstab Table

    By Spidey, June 1, 2020
    • 1 reply
    • 1.5k views
    • 
    • Ocean West
    • June 1, 2020

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

    By Philem63, June 1, 2020
    • 1 reply
    • 1.8k views
    • 
    • Ocean West
    • June 1, 2020

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

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

21. Merging duplicates with child records

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

22. Find Field via Relationship

    By sirsancho09, May 13, 2020
    • 6 replies
    • 2k views
    • 
    • sirsancho09
    • May 14, 2020

23. Get count of related records with specific field value

    By BrainlessBlock, May 7, 2020   

    • relationships
    • 1 reply
    • 2.8k views
    • 
    • comment
    • May 7, 2020

24. Display Related Field In Subsummary Part

    By Jay86, May 4, 2020   

    • related field
    • subsummary
    • (and 1 more)

       Tagged with:

      • related field
      • subsummary
      • lookup values
    • 3 replies
    • 2.1k views
    • 
    • Jay86
    • May 4, 2020

25. Multi Criteria Relationship Not Working

    By tiffany, April 30, 2020
    • 3 replies
    • 2k views
    • 
    • bcooney
    • April 30, 2020

26. Help with multiple relational paths

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

27. Failing relationship

    By aiharris, April 9, 2020
    • 1 reply
    • 2.2k views
    • 
    • comment
    • April 9, 2020

28. Portal Records Display

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

29. Scout Database

    By lewisandrea, March 14, 2020
    • 11 replies
    • 2.5k views
    • 
    • comment
    • March 14, 2020

30. Schema advice, please

    By Rich S, March 10, 2020
    • 1 reply
    • 1.9k views
    • 
    • Ocean West
    • March 10, 2020

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

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

32. Help with Project ID's

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

33. Portal showing sub-summaries

    By trvr, March 10, 2020   

    • Summary Data
    • filter portal table
    • 1 reply
    • 1.9k views
    • 
    • comment
    • March 10, 2020

34. Filemaker 16 Auction calendar with users' data HELP

    By Tony Martin, March 7, 2020   

    • relationships and portals
    • 1 reply
    • 1.7k views
    • 
    • Fitch
    • March 8, 2020

35. Multiple Drop Down Lists

    By Muz Riz, March 5, 2020
    • 2 replies
    • 1.7k views
    • 
    • Muz Riz
    • March 5, 2020