Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't find record in tlu w / key matching field tbl

Status
Not open for further replies.

dwAccessUser32

Programmer
Jan 16, 2007
20
0
0
US
I have a form that is related to two tables:

tluPermitType
PermitTypeID - PK
PermitType

tblPermit
PermitID - PK
JobID
PropertyID
PermitTypeID - FK
Abstract
Description

For some reason typing in data in the form I receive the error:

Can't find a record in tluPermitType w/key matching field(s) 'tblPermit_PermitTypeID'.

All of the other values don't seem to cause a problem.

tluPermitType has a one-to-many relationship with tblPermit on column PermitTypeID

Does anyone have any idea how to fix this? Any suggestions would be greatly appreciated.

 
If you have referential integrity, you must have a matching record in tluPermitType before adding a code to PermitTypeID.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top