I am creating a clinical research database and I am having trouble with some
of the design logic.

Each Protocol has a unique Budget.  Each Budget includes all the Visits
required for the study as well as which medical procedures are completed at
each visit and the corresponding fee.  These items are broken down to a per
Patient  $ amount.  Each Budget also includes overhead applied at the
Protocol level (non-patient specific).

The problem I'm having is how to track the completion and subsequent payment
for each visit for multiple Patients.

Example:  As of today, Patient X has completed Visits 1, 2, and 3 and the
corresponding fee is now due.  While Patient Y has completed only Visit 1,
with the corresponding fee now due.  etc.

Originally I created formProtocol with subformPatients with subdatasheet
Visits.  However this design requires the manual entry of the particulars for
each Visit and Medical Procedure for each Patient.  (Remember the particulars
are the same for each patient other than completion date.)  Is there a less
labor intensive method?