I have a table called
User that has
UserName as a primary key.
I want to establish a relationship with enforced referential integrity between
FriendRequest has the following:
UserNameA is the sender of the request and
UserNameB is the recpient. Accepting requests sets the relationship between A and B to friends. Rejecting deletes the row. No answer means that Accepted is set to FALSE.
The problem is that I can't enforce integrity and without it I can enter any user name for
UserNameB even if that particular
UserName does not even exist on UserProfile.
Is there a way to make my
FriendRequest table work in Access?
In this screenshot, before I added the second row for relationships, the relation type was displayed as one-to-many. As soon as I add the second relationship it becomes one-to-one.
Alright, I did it again (carefully this time). You were right that I did only create one relationship instead of two. However, I get this wierd duplication of the same table. Please take a look at the second screenshot. As you can see UserProfile was duplicated to UserProfile_1. But my list of actual existing tables only show that UserProfile exists. What exactly is UserProfile_1?