Relationship window, Enforce Referential Integrity Greyed out

[rhett7660]

Hello..

I have a simple database of 4 tables.

luTblJobTitle
JobTitleID (pk)
JobTitle

luTblReason
ReasonID(pk)
Reason

tblDateReason
DateReasonID(pk)
EntryNumber(fk)
Date
Reason
Entered

tblEmpMain
EntryNumber(pk)
EmployeeNumber
Etc//

I have a 1 to many setup between tblEmpMain and tblDateReason.

When I try to setup the relationship between the "reason" field in tblDateReason and luTblReason, Referential Integrity along with the other two check boxes are greyed out.

It still shows one to many but it will not let me enforce referential intergrity.

Why is this? Did I setup the database wrong? Or am I trying to do something I shouldn't be doing??

I have attached the db.. It is split with both the backend and the front end.

R~

 

[boblarson]

Are you trying to set relationships in the front-end of a FE/BE split? If so, you have to set them in the BE.

 

[rhett7660]

Bob..

Thanks.. I didn't even think about that.....

Thanks
R~