Relationships

5,945 topics in this forum

1. Creating a table to show multiple records of another table in one row

   By wattmhite, January 5, 2022
   • 1 reply
   • 425 views
   • 
   • comment
   • January 5, 2022

2. Help setting up tables and relationships based on XML

   By JMW, September 23, 2021   

   • relationships
   • 23 replies
   • 1.7k views
   • 
   • JMW
   • December 14, 2021

3. Creating a Value List in FMP 12 that is limited by the value in a field

   By gfr92y, November 8, 2021
   • 3 replies
   • 419 views
   • 
   • gfr92y
   • November 8, 2021

4. 3 Levels Multi-Select Picker

   By Amanco, August 5, 2021
   • 10 replies
   • 1.4k views
   • 
   • Amanco
   • September 7, 2021

5. Relationship and portal combination

   By sal88, August 25, 2021
   • 10 replies
   • 939 views
   • 
   • sal88
   • September 7, 2021

6. TEXT CALCULATION FIELDS

   By Simon Hall, August 24, 2021
   • 4 replies
   • 1.1k views
   • 
   • Simon Hall
   • August 25, 2021

7. RENUMBERING FIELDS IN JOINED TABLES

   By Simon Hall, August 24, 2021
   • 4 replies
   • 1.1k views
   • 
   • Simon Hall
   • August 24, 2021

8. How to tell if table/data is unused

   By MicheleC, August 17, 2021   

   • tables
   • table usage
   • (and 1 more)

      Tagged with:

     • tables
     • table usage
     • database cleanup
   • 2 replies
   • 997 views
   • 
   • MicheleC
   • August 17, 2021

9. Filter Relationship by type of child record?

   By Steve Martino, August 17, 2021
   • 2 replies
   • 637 views
   • 
   • Steve Martino
   • August 17, 2021

10. Filtering via relationship and current date

    By madman411, August 17, 2021
    • 2 replies
    • 631 views
    • 
    • madman411
    • August 17, 2021

11. m-to-n relationship via portal

    By MaxB, August 1, 2021
    • 8 replies
    • 891 views
    • 
    • bcooney
    • August 2, 2021

12. Methods of Creating Records

    By Amanco, July 22, 2021
    • 2 replies
    • 684 views
    • 
    • comment
    • July 23, 2021

13. Show certain related record

    By madman411, July 20, 2021
    • 2 replies
    • 467 views
    • 
    • madman411
    • July 22, 2021

14. Relate 2 records???

    By Greg58, June 29, 2021
    • 2 replies
    • 487 views
    • 
    • Greg58
    • June 30, 2021

15. Portals to display running player point totals for different people? Help (brain dead tonight)

    By Tony Martin, June 22, 2021
    • 1 reply
    • 495 views
    • 
    • comment
    • June 22, 2021

16. Unique value within parent record

    By madman411, May 17, 2021
    • 2 replies
    • 653 views
    • 
    • madman411
    • May 17, 2021

17. Relationship graph - can't work it out.

    By Greg58, May 11, 2021
    • 5 replies
    • 534 views
    • 
    • comment
    • May 12, 2021

18. Why can't I sort a table by a related field?

    By naio, April 24, 2021
    • 3 replies
    • 547 views
    • 
    • naio
    • May 7, 2021

19. Constants in relationships

    By passando, May 1, 2021
    • 2 replies
    • 505 views
    • 
    • comment
    • May 1, 2021

20. Go To Related Record, going to the wrong Table! (ie wrong direction)

    By Slater, March 22, 2021
    • 2 replies
    • 404 views
    • 
    • Slater
    • March 22, 2021

21. Self join set-up question

    By Hurlz, March 16, 2021
    • 2 replies
    • 386 views
    • 
    • Hurlz
    • March 17, 2021

22. Show record only if ...

    By Martin_01, March 11, 2021
    • 1 reply
    • 469 views
    • 
    • comment
    • March 11, 2021

23. Multi relationship

    By Chrism, March 2, 2021
    • 0 replies
    • 367 views
    • 
    • Chrism
    • March 2, 2021

24. Importing records from a text file and matching (maybe) misspelled names?

    By AJ Venice, February 26, 2021
    • 0 replies
    • 426 views
    • 
    • AJ Venice
    • February 26, 2021

25. Need conditional dropdown of values - just need help making sure my relationship is correct.

    By wfcperrine12, February 17, 2021
    • 2 replies
    • 386 views
    • 
    • wfcperrine12
    • February 18, 2021

26. Displaying portal info table occurances rather than original table

    By Hurlz, February 15, 2021
    • 3 replies
    • 484 views
    • 
    • Hurlz
    • February 17, 2021

27. I can't figure out how to retrieve a value based on two established values.

    By wfcperrine12, February 16, 2021
    • 2 replies
    • 418 views
    • 
    • wfcperrine12
    • February 16, 2021

28. Movie Database Multiple Actors, Directors Joining table

    By TaiChi56, February 14, 2021
    • 4 replies
    • 631 views
    • 
    • TaiChi56
    • February 14, 2021

29. Auto-fill a field based on a second table

    By Noam, January 28, 2021
    • 6 replies
    • 732 views
    • 
    • Noam
    • January 28, 2021

30. Stuck - need help schedule/enrollment update relationship?

    By AJ Venice, January 27, 2021
    • 0 replies
    • 358 views
    • 
    • AJ Venice
    • January 27, 2021

31. General Database Structure Query

    By Mark12345, January 27, 2021
    • 2 replies
    • 577 views
    • 
    • Ocean West
    • January 27, 2021

32. Do I Need to Create a Relational Data-base to Auto-generate a Field based on my Primary Key?

    By modern_archaeologist, January 19, 2021
    • 6 replies
    • 857 views
    • 
    • comment
    • January 21, 2021

33. Many to Many self-join

    By Hurlz, December 16, 2020
    • 6 replies
    • 644 views
    • 
    • Greg58
    • January 10, 2021

34. Multi-dimensional query - SQL hard-code or related tables?

    By DataCruncher, January 2, 2021
    • 5 replies
    • 477 views
    • 
    • comment
    • January 2, 2021

35. Creating an OR relationship

    By Chrism, December 10, 2020
    • 2 replies
    • 374 views
    • 
    • Chrism
    • December 10, 2020