Relationships

5,961 topics in this forum

1. Merge content from two tables or SQL View?

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

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

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

3. Create new table from Existing Field

   By ash1474, January 6, 2018
   • 3 replies
   • 2k views
   • 
   • Lee Smith
   • January 7, 2018

4. Withholding selected records from a portal

   By fumblewinter, December 13, 2017
   • 1 reply
   • 963 views
   • 
   • Fitch
   • December 13, 2017

5. Relating to a second table occurrence

   By BradDuns, December 12, 2017
   • 1 reply
   • 933 views
   • 
   • BradDuns
   • December 13, 2017

6. hierarchical Value List

   By Ahmed Adel, December 3, 2017
   • 1 reply
   • 1.4k views
   • 
   • Lee Smith
   • December 3, 2017

7. Non related record portal

   By Villmatt, November 26, 2017
   • 5 replies
   • 1.7k views
   • 
   • Villmatt
   • December 2, 2017

8. Can't show related portal records

   By Rob Ross, November 29, 2017
   • 5 replies
   • 1.1k views
   • 
   • rwoods
   • December 1, 2017

9. Displaying multiple relationships

   By jrm, November 29, 2017
   • 0 replies
   • 814 views
   • 
   • jrm
   • November 29, 2017

10. Adding multiple records to one table upon creating a new record on another table

    By xykudyax, November 16, 2017
    • 3 replies
    • 1k views
    • 
    • xykudyax
    • November 17, 2017

11. Don’t know how to approach this problem!

    By xykudyax, November 14, 2017
    • 5 replies
    • 1.8k views
    • 
    • xykudyax
    • November 14, 2017

12. Self-Join not working as should?

    By 'makerphile, November 6, 2017
    • 1 reply
    • 1.5k views
    • 
    • 'makerphile
    • November 10, 2017

13. normalization key question

    By rivet, November 5, 2017
    • 6 replies
    • 1.7k views
    • 
    • rivet
    • November 6, 2017

14. Match Field via Relationship

    By sirsancho09, November 6, 2017
    • 0 replies
    • 771 views
    • 
    • sirsancho09
    • November 6, 2017

15. Creating a view that includes only one value of multiples

    By Herb, November 4, 2017
    • 2 replies
    • 1k views
    • 
    • Herb
    • November 4, 2017

16. Tables Relationships

    By Karina_TX, October 25, 2017
    • 2 replies
    • 1.1k views
    • 
    • Karina_TX
    • October 25, 2017

17. What Relationship Must Be Established to Get Totals from Two Tables?

    By userfmp, October 21, 2017
    • 6 replies
    • 1.2k views
    • 
    • Fitch
    • October 24, 2017

18. Help with relationships

    By Karina_TX, October 20, 2017
    • 6 replies
    • 1.2k views
    • 
    • Karina_TX
    • October 23, 2017

19. Personnel Availability

    By Lowermountain, October 19, 2017
    • 0 replies
    • 1.4k views
    • 
    • Lowermountain
    • October 19, 2017

20. Non-functional join table

    By -dp-, October 14, 2017
    • 2 replies
    • 1.8k views
    • 
    • -dp-
    • October 15, 2017

21. GetSummary from two related tables

    By Toni, October 11, 2017
    • 6 replies
    • 2k views
    • 
    • Toni
    • October 13, 2017

22. Flagging records for later retrieval

    By Aussie John, August 7, 2017
    • 2 replies
    • 1.1k views
    • 
    • Aussie John
    • October 9, 2017

23. Relating 2 DB using a range of timestamps

    By dkey, September 22, 2017
    • 2 replies
    • 1.1k views
    • 
    • dkey
    • September 23, 2017

24. Printing line items with multiple tables.

    By RajaHashir, September 17, 2017
    • 4 replies
    • 1.6k views
    • 
    • RajaHashir
    • September 19, 2017

25. Safely replenish related Stock and edit parent record

    By sal88, September 11, 2017
    • 6 replies
    • 1.8k views
    • 
    • sal88
    • September 18, 2017

26. Many to many reports

    By Jure, September 13, 2017
    • 4 replies
    • 1.1k views
    • 
    • comment
    • September 14, 2017

27. My Recipe database needs help...

    By Mary Butterfelder, August 27, 2013
    • 32 replies
    • 9.6k views
    • 
    • HJS
    • September 7, 2017

28. Help with relationship

    By Lola, September 5, 2017
    • 5 replies
    • 1.4k views
    • 
    • bruceR
    • September 6, 2017

29. Can't get this relationship to work

    By muskee, August 29, 2017
    • 8 replies
    • 1.2k views
    • 
    • muskee
    • August 30, 2017

30. I'm in a bad relationship

    By John Chamberlain, August 26, 2017
    • 5 replies
    • 1.1k views
    • 
    • Lee Smith
    • August 26, 2017

31. Reading the (n)th record from a related table

    By Greg Hains, August 24, 2017
    • 6 replies
    • 1.6k views
    • 
    • Greg Hains
    • August 24, 2017

32. Totalling fields from a related table?

    By FMRadio, July 25, 2017
    • 7 replies
    • 1.3k views
    • 
    • Fitch
    • August 18, 2017

33. Reporting a string of child relationships

    By Aussie John, July 12, 2017
    • 2 replies
    • 865 views
    • 
    • Aussie John
    • August 7, 2017

34. Rebuilding-Relationship advice

    By Steve Martino, August 1, 2017
    • 0 replies
    • 776 views
    • 
    • Steve Martino
    • August 1, 2017

35. Join tables, I think...

    By Ben ECA, July 29, 2017
    • 5 replies
    • 1.2k views
    • 
    • comment
    • July 29, 2017