On 4 feb, 17:18, Lee Ann wrote:
Hoping this is a simple fix and my initial set up is correct. *I have a
number of tables in a DB which is tracking particular criminal activity. *For
the most part, other crimes may be involved with the main activity, but not
always (field may need to be blank). *When I try to pass that field without
entry, Access says "there's no matching record" and I have to add a crime for
it to save the record. *

My table set-up is:

TblAdditionalCriminalCharges
AdditionalCriminalChargesID(PK)
AdditionalCriminalCharges1
AdditionalCriminalCharges2
AdditionalCriminalCharges3
AdditionalCriminalCharges4

This table is joined to the table which houses the information pertaining to
the subject (criminal) by use of a FK titled AdditionalCriminalChargesID.

Thanks in advance for any assistance. *

Maybe the default values of the AdditionalCriminalCharges fields are
set to 0 (see tabel design).

By the way, I don't think it is a good idea to put repeating fields in
a table. Yoy better make a related table to store (any number of)
AdditionalCriminalCharges.

Groeten,

Peter
http://access.xps350.com