Microsoft Access Developer Interview Question:

Tell me why don't my table relationships show as '1' and '∞'? All I have is the line?

Submitted by: Muhammad

You have probably not chosen to have referential integrity checked when you created the relationship. Delete the relationship (click on the line then choose delete) and try again, this time choosing to have referential integrity checked.

Referential integrity is important. For example, in the Chelmer Leisure database, for the 1:m relationship between the Category and the Membership Tables, referential integrity will ensure that all member records have a membership type that is already listed in the Category table.
Submitted by: Muhammad