You're right - I have in fact changed the tDonationsToPayments table so that
the PaymentID is the primary key.
But aren't I still left with my "problem"? First, I created this "junction"
table to avoid the situation where the vast majority of Payment records will
have Null values in the DonationID field - since many payment records are not
donation payments, but for other things. So I have this junction table where
records are only created for donation payments.
My problem, given this table design, is that the Donation record and Payment
record both need to be created before the junction table can be filled in -
but it's the junction table that is the record source of the subform!
Should I just live with the empty DonationID fields in the tPayments table,
and get on with my life??