The Microsoft Jet database engine cannot find a record in the table"with key matching fields"

[Dejan M.]

Please can you help me with this problem:

In the next form, when I Add new person who is not registered in the base I
had the massage: The Microsoft Jet database engine cannot find a record in
the table 'CLAN' with key matching field(s) JMBG.
The question is: How to add data for the unregistered visitors in the next
fields:

JMBG (unique person number);(translation)
STATUS;
IME (name);
PREZIME (surname);
GRAD (town);
UPLACENO (payment)
NAPOMENA (comment)

If you want I can send you mdb.zip. Thank you very much.

 

[[MVP] S. Clark]

I'll assume that you have a parent to child relationship, with Referential
Integrity enforced between the two. You are attempting to add a child
record, without adding the parent first. This is not possible, so you will
need to populate the parent table first, then write the parent record.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-