[AccessD] matching field error

Pedro
The implication is that the you have Relationships defined with referential
integrity. You are saving a record with a test id which doesn't match to a
key value in the tblTest table. The odd thing is that this shouldn't occur
if the fields are Null. Is there any way they could have zeroes or
zero-length strings rather tha  nulls, because that would do it.

Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Pedro Janssen
> Sent: 09 December 2003 22:41
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] matching field error
> 
> 
> Hello Group,
> 
> i get the following error in a form, when i close it and the 
> field 'PrTestID' is empty:
> 
> The microsoft Jet database engine cannot find a record in 
> table 'tblTest' with key matching field(s) 'PrTestID'
> 
> 
> How is this possible, because the field isn't required?
> Al the ID fields in the form give the same error when they 
> are empty (and all aren't reqiured).
> 
> 
> 
> Pedro Janssen
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
> 
>