Search results

  1. Y

    Create New Record In MainForm when Editting SubForm

    I have a MainForm linked to a SubForm (1 to many relationship). If I go to add a new record in the MainForm and begin entering data in the MainForm everything works properly (The MainForm AutoNumber PK gets generated and the corresponding SubForm FK gets set to the number that was generated)...
    • Yak77
    • Thread
    • Replies: 2
    • Forum: Forms
  2. Y

    What is the best Table Structure?

    Thank you for the replies. I updated the Original Post with a hopefully more clear example of what the database will look like. In my attempt to try to not confuse people with the actual names of the exams, I probably managed to do the exact opposite. Basically, an Episode of Care is...
  3. Y

    What is the best Table Structure?

    Hi All, I am trying to help a friend create a database for a rehab hospital. When Patients are admitted they run a series of exams on them and when they are discharged they run the same exams. The same Patient could come back multiple times, so each time they come back ("Episode of Care")...
Back
Top Bottom