Search results

  1. L

    Creating a continuous subform with same information

    @jdraw Actually multiple surgeons could be in one surgery but we record only 1 surgeon as representative and we only record 1 staff as the "input staff" for each operation. So they can merely be a drop down list to choose surgeon/input staff for each operation, and staff members will be chosen...
  2. L

    Creating a continuous subform with same information

    @Minty @Micron @zeroaccess @jdraw Thank you for your information! I've re-designed the whole thing into 4 tables named tblOperation (contain the information of each operation with a unique code called "HN number"), tblConsumable (contain the consumed items with a linkage at "HN number" with...
  3. L

    Creating a continuous subform with same information

    @theDBguy @Minty Thanks! I am newbie to Access so I tried many times and didn't get much of the work done....However, here is what I need in the master table For example, a patient underwent a surgery today, and this patient used 14 items in that surgery, then the first 6 columns will be...
  4. L

    Creating a continuous subform with same information

    I am creating an input form for medical staff to record the used medical consumables for each operation. For each operation, there will be a unique case no., patient name, operation date, operation name and surgeon, however, multiple items will be used for each operation. I created a main form...
Top Bottom