Normally,Access prohibits the deletion of a record in which the primary key matches a foreign key in another table.

It is more secure for a buyer to use the telephone or mail to arrange or send payments than to use a computer.