Relationships

5,959 topics in this forum

1. Many to many self-relationship Redux

   By Brad Mathews, March 26, 2016
   • 2 replies
   • 1.2k views
   • 
   • Brad Mathews
   • March 27, 2016

2. ERD Table Trouble

   By Abigail Elizabeth, March 23, 2016
   • 2 replies
   • 905 views
   • 
   • Abigail Elizabeth
   • March 23, 2016

3. How do I create a value list which contains records from two tables

   By plchri, March 21, 2016
   • 4 replies
   • 929 views
   • 
   • plchri
   • March 21, 2016

4. Table Relationships advice needed

   By UltraNIX, March 16, 2016
   • 5 replies
   • 1k views
   • 
   • Wim Decorte
   • March 20, 2016

5. Copy records from FM to MySQL

   By Marcwa19197, February 24, 2016
   • 8 replies
   • 1.3k views
   • 
   • ggt667
   • March 14, 2016

6. Help with Container

   By muskee, March 10, 2016
   • 1 reply
   • 844 views
   • 
   • bcooney
   • March 10, 2016

7. Self join Relationship or New Table?

   By Dimitrios Fkiaras, March 9, 2016
   • 5 replies
   • 1k views
   • 
   • Lee Smith
   • March 9, 2016

8. How to show related fields in another table.

   By nareyramos, March 9, 2016
   • 2 replies
   • 873 views
   • 
   • LaRetta
   • March 9, 2016

9. Psychotherapy DB

   By Auraboros, February 4, 2016
   • 27 replies
   • 2k views
   • 
   • Auraboros
   • March 2, 2016

10. Portal to show all records for selected record

    By Chris Thacker, February 29, 2016
    • 12 replies
    • 1k views
    • 
    • Chris Thacker
    • March 1, 2016

11. Guidelines for when to make a new table?

    By nycpost, February 28, 2016
    • 4 replies
    • 1k views
    • 
    • Fitch
    • February 29, 2016

12. Relationship with spaces in field values

    By pjulian, February 29, 2016
    • 1 reply
    • 703 views
    • 
    • comment
    • February 29, 2016

13. Multi-Predicate or Alternative Key

    By Ocean West, February 26, 2016
    • 0 replies
    • 922 views
    • 
    • Ocean West
    • February 26, 2016

14. Many to Many ralationship

    By H, February 25, 2016
    • 1 reply
    • 877 views
    • 
    • comment
    • February 25, 2016

15. Parent and child records in same portal with relationship doesnt exist

    By Gerry, February 22, 2016
    • 2 replies
    • 953 views
    • 
    • Gerry
    • February 23, 2016

16. Taxonomy database setup advise

    By Alex8, February 9, 2016   

    • taxonomy
    • database
    • (and 2 more)

       Tagged with:

      • taxonomy
      • database
      • hierarchy
      • setup
    • 7 replies
    • 2.2k views
    • 
    • Alex8
    • February 18, 2016

17. Trying to organize a company->company->employee database

    By Hoytopher, February 9, 2016   

    • sorting
    • organization
    • 5 replies
    • 2.5k views
    • 
    • comment
    • February 17, 2016

18. Self-Join Relationship for finding Duplicate Value with "OR" condition

    By dav1089, February 12, 2016   

    • self-join
    • relationship
    • (and 1 more)

       Tagged with:

      • self-join
      • relationship
      • duplicate records with similar fields
    • 4 replies
    • 1.6k views
    • 
    • dav1089
    • February 16, 2016

19. Use of Portal on Unrelated Table on Main Menu

    By John Kostenbader, February 12, 2016
    • 3 replies
    • 1.1k views
    • 
    • comment
    • February 13, 2016

20. Creating New Contact from Company Table

    By BeginnerForever, December 10, 2015   

    • contact
    • company
    • (and 4 more)

       Tagged with:

      • contact
      • company
      • tables
      • relationships
      • fields
      • popover
    • 9 replies
    • 2.6k views
    • 
    • M_ichel
    • February 11, 2016

21. One to many - many to one with four tables

    By frankb3, February 10, 2016
    • 0 replies
    • 848 views
    • 
    • frankb3
    • February 10, 2016

22. Can't get MaxDate from external FM file

    By b.hunt, February 10, 2016
    • 1 reply
    • 633 views
    • 
    • webko
    • February 10, 2016

23. Please Please Help!!!

    By cheerfulzebra, February 10, 2016   

    • hire database
    • 5 replies
    • 1k views
    • 
    • Fitch
    • February 10, 2016

24. Calling two separate related records

    By mmarino, February 10, 2016
    • 2 replies
    • 763 views
    • 
    • Kris M
    • February 10, 2016

25. One-to-Many Relationship with OR operator?

    By Dimitrios Fkiaras, February 8, 2016   

    • one-many
    • or-operator
    • (and 1 more)

       Tagged with:

      • one-many
      • or-operator
      • multipe-match-fields
    • 2 replies
    • 964 views
    • 
    • Dimitrios Fkiaras
    • February 9, 2016

26. Related data all in one field

    By Tpaairman, February 6, 2016
    • 6 replies
    • 1.4k views
    • 
    • comment
    • February 9, 2016

27. Files & Tables Consolidation

    By SarahS, February 1, 2016
    • 4 replies
    • 1.5k views
    • 
    • SarahS
    • February 3, 2016

28. Need Help Creating Enrollment Form

    By Briana, February 2, 2016   

    • enrollmentform
    • checklist
    • (and 1 more)

       Tagged with:

      • enrollmentform
      • checklist
      • pc
    • 5 replies
    • 1.6k views
    • 
    • comment
    • February 3, 2016

29. Proper structure to archive data

    By Greg Tuite, February 3, 2016
    • 0 replies
    • 699 views
    • 
    • Greg Tuite
    • February 3, 2016

30. Filtering by Related Record

    By mmarino, February 2, 2016   

    • related record
    • filter
    • 0 replies
    • 3.8k views
    • 
    • mmarino
    • February 2, 2016

31. Relating tables with month and year

    By Agentshevy, January 29, 2016   

    • relationship
    • month
    • (and 1 more)

       Tagged with:

      • relationship
      • month
      • year
    • 15 replies
    • 1.6k views
    • 
    • Agentshevy
    • February 2, 2016

32. Lookup field when related records change

    By Matt Malyschko, January 30, 2016
    • 2 replies
    • 1k views
    • 
    • Matt Malyschko
    • January 31, 2016

33. How to manage hundreds of fields and their related records

    By Jo_In_Oz, January 25, 2016   

    • fields
    • tables
    • (and 1 more)

       Tagged with:

      • fields
      • tables
      • relationships
    • 31 replies
    • 3.8k views
    • 
    • Jo_In_Oz
    • January 29, 2016

34. Invalid Table relationship

    By Spidey, January 27, 2016
    • 3 replies
    • 1.1k views
    • 
    • webko
    • January 27, 2016

35. FM Relationship Error Message

    By Spidey, January 26, 2016   

    • relationship
    • 2 replies
    • 2k views
    • 
    • Spidey
    • January 26, 2016