Jump to content

Tables, Views and Relationships

Discussions around data model and working with tables, Views and relationships.

Explore Questions

There are no popular questions to show right now

660 questions in this forum

  1. I want to restrict no of records in the table on base of user input

    Asked by Mushigee2266,

    0 votes
    1 answer

  2. Running Mathematical Formula on inserted data

    Asked by Saurabh,

    0 votes
    4 answers

  3. Display Summary of Entries on Table

    Asked by raoncilio,

    0 votes
    1 answer

  4. Add info about a table?

    Asked by JohnM,

    0 votes
    3 answers

  5. Create an 'add new' button on form (adds max value of table + 1)

    Asked by raoncilio,

    0 votes
    1 answer

  6. Building a Searchable Client Base

    Asked by pdavis1958,

    0 votes
    3 answers

  7. Create tables and relation to store user specific detail for each row of the main table

    Asked by Prinapo,

    0 votes
    1 answer

  8. Trouble finding correct syntax in triggers to calculate an amount in a loop

    Asked by Mary99,

    0 votes
    2 answers

  9. Consequesnce for changing field names in a table

    Asked by rstglobal,

    0 votes
    7 answers

  10. Display Age as Years,Months

    Asked by Leigh,

    0 votes
    6 answers

  11. One-time bulk update, based on a lookup

    Asked by JohnM,

    0 votes
    2 answers

  12. Changing data field to show look-up ID rather than original text

    Asked by oliverk,

    0 votes
    5 answers

  13. Check if table children exists in other table

    Asked by KG360,

    0 votes
    4 answers

  14. Pivot Table columns displays as rows on mobile.

    Asked by CTW2020,

    0 votes
    2 answers

  15. Reports Format Glitch

    Asked by MonicaT,

    0 votes
    3 answers

  16. Insert Trigger - Insert Only on First Matching Condition

    Asked by kpcollier,

    0 votes
    3 answers

  17. Insert and Update Sums in other Table

    Asked by emarchewka,

    0 votes
    8 answers

  18. Triggered action for updating the status based on the status change in another table

    Asked by Aleksandra,

    0 votes
    8 answers

  19. Trigger keeps returning false.

    Asked by NiceDuck,

    0 votes
    5 answers

  20. If Logic

    Asked by RonAnderson,

    0 votes
    15 answers

  21. 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,

    0 votes
    1 answer

  22. How to write SQL code that does not add a separator to the end of the concatenated list

    Asked by heinepeople,

    0 votes
    2 answers

  23. Triggered action for add new record

    Asked by Jeroen,

    0 votes
    2 answers

  24. Expressions in Triggers

    Asked by RBobowski,

    0 votes
    3 answers

  25. Duplicate Records Being Created from Submission Form

    Asked by ChristianM,

    0 votes
    14 answers
×
×
  • Create New...