Relationships

5,960 topics in this forum

1. Display found count from one layout in another layout.

   By Ronan, May 3, 2019
   • 2 replies
   • 855 views
   • 
   • Ronan
   • May 3, 2019

2. Lookup fields showing negative numbers as positibe

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

3. Portal Woes and other dilemas

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

4. Many to Many relationship?

   By Answers, March 20, 2019
   • 4 replies
   • 1k views
   • 
   • Answers
   • March 21, 2019

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

   By owangolama, February 22, 2019
   • 6 replies
   • 1.2k views
   • 
   • owangolama
   • February 26, 2019

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

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

7. Duplicating all the items in an order

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

8. School Management System for teacher

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

9. Multiple Choice for Data Insertion

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

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

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

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

    By apinrise, January 22, 2019
    • 14 replies
    • 1k views
    • 
    • apinrise
    • January 22, 2019

12. Dynamically updating a relationship for filtering

    By stefangs, November 20, 2018
    • 6 replies
    • 1k views
    • 
    • stefangs
    • November 21, 2018

13. Filter contents of drop down

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

14. Multiple Company Shared Database Anchor Buoy

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

15. Relationship for finding earliest date a given goal is achieved

    By alanf, October 16, 2018
    • 12 replies
    • 1.3k views
    • 
    • alanf
    • October 19, 2018

16. How are these Orphans created

    By Oyseka, October 13, 2018
    • 8 replies
    • 2.3k views
    • 
    • LaRetta
    • October 14, 2018

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

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

18. Summarize data between three tables

    By Scott Pon, September 21, 2018
    • 2 replies
    • 939 views
    • 
    • Scott Pon
    • September 25, 2018

19. Conditional Value Lists using a ValueList table?

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

20. Need Schema Advice for Setting Up a Report

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

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

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

22. Unidirectional Cartesian Join

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

23. Counting fields in related table

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

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

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

25. Many to Many Relationships

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

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

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

27. What relationship to use?

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

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

    By Joe_Schmo, February 21, 2012
    • 35 replies
    • 9.6k views
    • 
    • Lee Smith
    • May 17, 2018

29. One Master Product Catalogue - Many POS Different Locations

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

30. Managing Gaps in Numbering Sequences

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

31. Genealogy: Relational database(s)

    By DaCo, March 13, 2018
    • 6 replies
    • 2k views
    • 
    • Tom R.
    • March 20, 2018

32. Relationship Woes__ not just at home anymore :)

    By LabMole, March 12, 2018
    • 0 replies
    • 848 views
    • 
    • LabMole
    • March 12, 2018

33. Customer Referral Program

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

34. Script loses related records

    By Asu, February 12, 2018
    • 3 replies
    • 1.2k views
    • 
    • Asu
    • February 13, 2018

35. Merge content from two tables or SQL View?

    By Rob Ross, February 5, 2018
    • 4 replies
    • 1.3k views
    • 
    • Rob Ross
    • February 6, 2018