0

Help for a link

Good Evening. I would like your help. I want in a form to link the date to the notes, so that on each new date I have new notes. how will I do it

4 replies

null
    • Choices_Software_Dean
    • 4 yrs ago
    • Reported - view

    You could have a forms table with a related notes table. The notes table would include a date column that defaults to the current date each time a new notes record is created. Show the related notes table in a view on the form.

     

    Or you could just have your forms table with a date column and set the date column to show in the Calendar. That way the calendar would show your "notes".

     

    We really need more information about your data structure to help you.

    • info.20
    • 4 yrs ago
    • Reported - view

    my problem is the following: my profession is a doctor i have made a database so that each patient has his card. each patient comes more than once. i want when i set the date to open new notes for each patient so i know each visit What was his problem that day Thank you

    • Choices_Software_Dean
    • 4 yrs ago
    • Reported - view

    First of all, thank you for being a doctor. Your work is very much appreciated!

    Try the following steps, to quickly create a sample solution for tracking patient visits:

    1. click "New Database"/New/Start with...
    2. name new database "Patient Visits"
    3. click "Create database"
    4. click "Data model" tab
    5. click "New table"
    6. change Table name to "Patients"
    7. drag text field from right to center
    8. rename field "Patient Name"
    9. click "Save Changes"
    10. click "New table" again
    11. rename new table "Visits"
    12. drag "Date" field from right to center
    13. double-click "Date"
    14. change Default value property to "Today"
    15. click "OK" to save
    16. drag "Text(multiline)" field to center
    17. rename the field "Notes"
    18. click "Create table reference" (at lower right)
    19. drag "Patients" to center (under Notes)
    20. click "Save Changes"
    21. click "Patients" at far left
    22. click under "Patient Name" (to create new record)
    23. enter "John Doe"
    24. at right under John Doe/Visits, click + button
    25. enter Note describing patient's visit
    26. Date field should show date of patient's visit

     

    Hope this helps.

    • info.20
    • 4 yrs ago
    • Reported - view

    thank you very much for the prompt reply i will try it on friday i will be in the doctor's office thank you again

Content aside

  • 4 yrs agoLast active
  • 4Replies
  • 825Views