I have a table called Referrals.  I need to add a button to that form to
allow users to add records to table called Deferred.  Records in the Deferred
table must have a record in a table called Donors.  My problem is when that
relationship does not exist yet.

I figured out how to check to see if there's a matching record in the Donor
table but what I can't figure out is how to create the record if it's not
there.  I need to create a new record in the Donors table and fill in one
field.  The problem is that the Donors table is not open at this point - the
form the user is in is based on the Referrals table.  Is there a way to
create a record in a table that isn't open?