Relationships

5,960 topics in this forum

1. join table question - multiple users?

   By human, November 7, 2022
   • 13 replies
   • 1.1k views
   • 
   • comment
   • November 13, 2022

2. Is a portal empty

   By Raymack, November 1, 2022
   • 3 replies
   • 1.3k views
   • 
   • Raymack
   • November 1, 2022

3. Populating a Relational Database from available data files

   By Raymack, October 20, 2022
   • 8 replies
   • 1.1k views
   • 
   • Raymack
   • October 23, 2022

4. Reporting Subsummary results from a CheckBox Set

   By Raymack, October 12, 2022
   • 8 replies
   • 1.2k views
   • 
   • Raymack
   • October 13, 2022

5. transfer a found set to a different already-existent window

   By Glenn S., June 24, 2018
   • 11 replies
   • 1.9k views
   • 
   • GFS
   • September 20, 2022

6. Count of related records, sort of

   By RSGC, August 27, 2022
   • 5 replies
   • 543 views
   • 
   • comment
   • August 28, 2022

7. Unmodifiable field

   By carlosnorvik, August 4, 2022
   • 2 replies
   • 770 views
   • 
   • comment
   • August 17, 2022

8. Base Table vs TO - foreign key

   By centauri272, August 4, 2022
   • 9 replies
   • 1k views
   • 
   • centauri272
   • August 12, 2022

9. Getting sort order of Portal as a number back to a different Table

   By Slater, June 10, 2022
   • 5 replies
   • 1.1k views
   • 
   • Slater
   • June 13, 2022

10. Venue clash checking based on multiple criteria

    By Bullion, May 18, 2022
    • 4 replies
    • 1k views
    • 
    • comment
    • May 18, 2022

11. Conditional Value List works in one DB but not another?

    By Bullion, May 3, 2022
    • 4 replies
    • 1k views
    • 
    • Bullion
    • May 3, 2022

12. Simple value list question (I hope)

    By muzz, March 27, 2022
    • 3 replies
    • 881 views
    • 
    • muzz
    • April 4, 2022

13. Portal displaying some but not all related records

    By relatively, April 3, 2022
    • 3 replies
    • 810 views
    • 
    • comment
    • April 4, 2022

14. Portal filtering includes empty values

    By muzz, March 20, 2022
    • 6 replies
    • 1.4k views
    • 
    • muzz
    • March 25, 2022

15. Strange behavior (related calculations)

    By tomislaw, March 15, 2022
    • 0 replies
    • 877 views
    • 
    • tomislaw
    • March 15, 2022

16. The portal show the "wrong" data, what I am missing?

    By tomislaw, February 20, 2022
    • 10 replies
    • 1.3k views
    • 
    • tomislaw
    • February 22, 2022

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

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

18. Help setting up tables and relationships based on XML

    By JMW, September 23, 2021
    • 23 replies
    • 2.6k views
    • 
    • JMW
    • December 14, 2021

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

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

20. 3 Levels Multi-Select Picker

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

21. Relationship and portal combination

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

22. TEXT CALCULATION FIELDS

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

23. RENUMBERING FIELDS IN JOINED TABLES

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

24. How to tell if table/data is unused

    By MicheleC, August 17, 2021
    • 2 replies
    • 1.3k views
    • 
    • MicheleC
    • August 17, 2021

25. Filter Relationship by type of child record?

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

26. Filtering via relationship and current date

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

27. m-to-n relationship via portal

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

28. Methods of Creating Records

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

29. Show certain related record

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

30. Relate 2 records???

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

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

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

32. Unique value within parent record

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

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

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

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

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

35. Constants in relationships

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