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

639 questions in this forum

  1. Non-equal joins

    Asked by JohnM,

    0 votes
    4 answers

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

    Asked by Mushigee2266,

    0 votes
    1 answer

  3. Running Mathematical Formula on inserted data

    Asked by Saurabh,

    0 votes
    4 answers

  4. Display Summary of Entries on Table

    Asked by raoncilio,

    0 votes
    1 answer

  5. Add info about a table?

    Asked by JohnM,

    0 votes
    3 answers

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

    Asked by raoncilio,

    0 votes
    1 answer

  7. Building a Searchable Client Base

    Asked by pdavis1958,

    0 votes
    3 answers

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

    Asked by Prinapo,

    0 votes
    1 answer

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

    Asked by Mary99,

    0 votes
    2 answers

  10. Consequesnce for changing field names in a table

    Asked by rstglobal,

    0 votes
    7 answers

  11. Display Age as Years,Months

    Asked by Leigh,

    0 votes
    6 answers

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

    Asked by JohnM,

    0 votes
    2 answers

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

    Asked by oliverk,

    0 votes
    5 answers

  14. Check if table children exists in other table

    Asked by KG360,

    0 votes
    4 answers

  15. Pivot Table columns displays as rows on mobile.

    Asked by CTW2020,

    0 votes
    2 answers

  16. Reports Format Glitch

    Asked by MonicaT,

    0 votes
    3 answers

  17. Insert Trigger - Insert Only on First Matching Condition

    Asked by kpcollier,

    0 votes
    3 answers

  18. Insert and Update Sums in other Table

    Asked by emarchewka,

    0 votes
    8 answers

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

    Asked by Aleksandra,

    0 votes
    8 answers

  20. Trigger keeps returning false.

    Asked by NiceDuck,

    0 votes
    5 answers

  21. If Logic

    Asked by RonAnderson,

    0 votes
    15 answers

  22. 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

  23. 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

  24. Triggered action for add new record

    Asked by Jeroen,

    0 votes
    2 answers

  25. Expressions in Triggers

    Asked by RBobowski,

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