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)...
  2. 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