Tables, Views and Relationships

642 questions in this forum

1. Comparing data from a set of 4 tables to a 5th table. From there, modifying/deleting/adding records to the 5th table based on missing information from #1-4

   Asked by chuckiecc, January 29, 2022

   0 votes
   1 answer
2. How to write SQL code that does not add a separator to the end of the concatenated list

   Asked by heinepeople, March 29, 2019

   • sql
   • lists
   • datapage
   • calculated fields
   0 votes
   2 answers
3. Triggered action for add new record

   Asked by Jeroen, August 12, 2022

   0 votes
   2 answers
4. Expressions in Triggers

   Asked by RBobowski, May 13, 2018

   • trigger
   • alias
   • expression
   0 votes
   3 answers
5. Duplicate Records Being Created from Submission Form

   Asked by ChristianM, July 15, 2022

   • submission form
   • insert record
   • duplicate
   0 votes
   14 answers
6. Conditional display of link in a table

   Asked by SteveMott, August 12, 2022

   0 votes
   2 answers
7. Submission form - ID value is shown instead of field name

   Asked by Aleksandra, August 1, 2022

   1 vote
   4 answers
8. Total & Aggregration (Avg function) - how to round up to 2 decimal place

   Asked by kytan5, September 8, 2016

   • total
   • aggregration
   • average
   • calculation
   • datapage
   0 votes
   3 answers
9. Need Parent Data in Child Table

   Asked by Rupesh, July 23, 2022

   0 votes
   4 answers
10. Tables and records automation

    Asked by GUSTAVO, October 25, 2020

    0 votes
    5 answers
11. Running Balance per Transaction

    Asked by Benades, April 16, 2021

    • sum
    • balance
    • table
    • history of changes
    • update
    0 votes
    8 answers
12. Solution - View of IDs Based on 2 Fields

    Asked by ChristianM, July 15, 2022

    • view
    • criteria
    • tables
    1 vote
    0 answers
13. Run trigger on Password Update

    Asked by NiceDuck, June 19, 2021

    1 vote
    4 answers
14. Remove currency format in update form

    Asked by wgalliance, September 20, 2016

    • masking
    • format
    • script
    0 votes
    4 answers
15. Copying child records from one table to another

    Asked by scribblemilk, September 13, 2016

    • record copy
    0 votes
    4 answers
16. How to store look up table "Field for display" for later use?

    Asked by Simong, August 24, 2016

    • look up table
    0 votes
    3 answers
17. Trigger to draw table from another table.

    Asked by oliverk, June 23, 2022

    0 votes
    3 answers
18. Re-using Table Variable within a loop

    Asked by Lepidoptera, June 16, 2022

    • trigger
    • task
    • table variable
    • set table varible
    0 votes
    1 answer
19. SMS action in trigger not working

    Asked by Carioca, October 24, 2019

    • sms
    • trigger
    0 votes
    7 answers
20. Different SMS for Insert vs. Delete Triggered action

    Asked by Fleshzombie, September 2, 2021

    0 votes
    4 answers
21. Hide all records from one table when associated table has records of a certain value

    Asked by GreenTurtle, April 5, 2022

    0 votes
    2 answers
22. Remove Underscore in a Table

    Asked by mrsuave, June 5, 2022

    0 votes
    3 answers
23. How can I leave dropdown search fields blank, it always defaults to the top value

    Asked by TNathan, May 20, 2022

    0 votes
    3 answers
24. Calculate no. of working days excluding weekends and holidays using Tasks

    Asked by cheonsa, April 5, 2022

    0 votes
    2 answers
25. How to put records from one table into another table?

    Asked by Aleksandra, May 26, 2022

    0 votes
    6 answers