Relationships

5,959 topics in this forum

1. Lookup fields showing negative numbers as positibe

   By Grapes, May 2, 2019
   • 2 replies
   • 938 views
   • 
   • LaRetta
   • May 3, 2019

2. Portal Woes and other dilemas

   By Limore, April 23, 2019
   • 3 replies
   • 787 views
   • 
   • bcooney
   • April 23, 2019

3. Many to Many relationship?

   By Answers, March 20, 2019   

   • relationships portals
   • 4 replies
   • 1k views
   • 
   • Answers
   • March 21, 2019

4. Obtaining looked-up data based on a list stored in a field

   By owangolama, February 22, 2019   

   • relationships
   • lists
   • (and 1 more)

      Tagged with:

     • relationships
     • lists
     • joins
   • 6 replies
   • 1.2k views
   • 
   • owangolama
   • February 26, 2019

5. Summing the value of a child with more "childs"

   By fousthvk, February 18, 2019
   • 1 reply
   • 842 views
   • 
   • Ocean West
   • February 18, 2019

6. Duplicating all the items in an order

   By Angus McKinnon, May 5, 2015
   • 2 replies
   • 1.1k views
   • 
   • Aussie John
   • February 8, 2019

7. School Management System for teacher

   By Brecht, January 23, 2019
   • 13 replies
   • 2.8k views
   • 
   • Brecht
   • February 2, 2019

8. Multiple Choice for Data Insertion

   By Rich M, January 31, 2019
   • 5 replies
   • 860 views
   • 
   • Rich M
   • February 1, 2019

9. How to Display Child Related Tables (ie projects) on Parent Account Portals

   By 50x50, January 27, 2019
   • 2 replies
   • 1k views
   • 
   • Steve Martino
   • January 27, 2019

10. fk of join table won't connect but 'go to related' script does

    By apinrise, January 22, 2019
    • 14 replies
    • 977 views
    • 
    • apinrise
    • January 22, 2019

11. Dynamically updating a relationship for filtering

    By stefangs, November 20, 2018
    • 6 replies
    • 995 views
    • 
    • stefangs
    • November 21, 2018

12. Filter contents of drop down

    By Gismo12, November 13, 2018
    • 1 reply
    • 1.1k views
    • 
    • rwoods
    • November 13, 2018

13. Multiple Company Shared Database Anchor Buoy

    By cat traveller, September 9, 2018
    • 2 replies
    • 937 views
    • 
    • cat traveller
    • October 20, 2018

14. fmp17 Relationship for finding earliest date a given goal is achieved

    By alanf, October 16, 2018   

    • Relationships
    • Selfjoin
    • 12 replies
    • 1.3k views
    • 
    • alanf
    • October 19, 2018

15. How are these Orphans created

    By Oyseka, October 13, 2018   

    • Relationship
    • 8 replies
    • 2.3k views
    • 
    • LaRetta
    • October 14, 2018

16. can't get this summary data the way i want it

    By Jrav, October 5, 2018
    • 0 replies
    • 694 views
    • 
    • Jrav
    • October 5, 2018

17. Summarize data between three tables

    By Scott Pon, September 21, 2018   

    • fmp13
    • 2 replies
    • 924 views
    • 
    • Scott Pon
    • September 25, 2018

18. Conditional Value Lists using a ValueList table?

    By gczychi, September 9, 2018
    • 1 reply
    • 1.1k views
    • 
    • gczychi
    • September 22, 2018

19. Need Schema Advice for Setting Up a Report

    By Rich, August 21, 2018
    • 0 replies
    • 819 views
    • 
    • Rich
    • August 21, 2018

20. Self-Join to sort records that have an empty field

    By 'makerphile, July 11, 2018
    • 1 reply
    • 1.3k views
    • 
    • bcooney
    • July 15, 2018

21. Unidirectional Cartesian Join

    By Peter Lehrack, June 27, 2018
    • 1 reply
    • 1.4k views
    • 
    • Peter Lehrack
    • June 29, 2018

22. Counting fields in related table

    By Greg Hains, June 2, 2018
    • 4 replies
    • 1.2k views
    • 
    • Greg Hains
    • June 2, 2018

23. Flag if any of the related records contain "TEXT"

    By DataCruncher, May 28, 2018
    • 2 replies
    • 896 views
    • 
    • rwoods
    • May 29, 2018

24. Many to Many Relationships

    By ann, May 25, 2018
    • 1 reply
    • 870 views
    • 
    • bcooney
    • May 25, 2018

25. How can I get this many-to-many self-join to show related records?

    By Chuck, May 22, 2018   

    • portal
    • 1 reply
    • 1.1k views
    • 
    • Steve Martino
    • May 22, 2018

26. What relationship to use?

    By Anuviel, May 17, 2018
    • 2 replies
    • 834 views
    • 
    • Anuviel
    • May 21, 2018

27. filtering portal by global field locks all records for editing to other users 1 2

    By Joe_Schmo, February 21, 2012   

    • portal
    • global field
    • (and 1 more)

       Tagged with:

      • portal
      • global field
      • filter
    • 35 replies
    • 9.5k views
    • 
    • Lee Smith
    • May 17, 2018

28. One Master Product Catalogue - Many POS Different Locations

    By tbcomputerguy, April 23, 2018
    • 1 reply
    • 856 views
    • 
    • OlgerDiekstra
    • April 25, 2018

29. Managing Gaps in Numbering Sequences

    By Wickerman, April 18, 2018
    • 0 replies
    • 764 views
    • 
    • Wickerman
    • April 18, 2018

30. Genealogy: Relational database(s)

    By DaCo, March 13, 2018   

    • genealogy
    • 6 replies
    • 1.9k views
    • 
    • Tom R.
    • March 20, 2018

31. Relationship Woes__ not just at home anymore :)

    By LabMole, March 12, 2018   

    • relationships
    • 0 replies
    • 833 views
    • 
    • LabMole
    • March 12, 2018

32. Customer Referral Program

    By Kevin Moody, February 22, 2018
    • 0 replies
    • 719 views
    • 
    • Kevin Moody
    • February 22, 2018

33. Script loses related records

    By Asu, February 12, 2018   

    • indexing
    • related records
    • 3 replies
    • 1.2k views
    • 
    • Asu
    • February 13, 2018

34. Merge content from two tables or SQL View?

    By Rob Ross, February 5, 2018   

    • sql view
    • merge
    • (and 1 more)

       Tagged with:

      • sql view
      • merge
      • combine tables
    • 4 replies
    • 1.2k views
    • 
    • Rob Ross
    • February 6, 2018

35. Record modification creates a new record in a related tables

    By spand, January 18, 2018
    • 2 replies
    • 1.2k views
    • 
    • Lee Smith
    • January 18, 2018