Tell me why don't my table relationships show as '1' and '∞'? All I have is the line?
Submitted by: MuhammadYou 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
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
Read Online Microsoft Access Developer Job Interview Questions And Answers
Top Microsoft Access Developer Questions
☺ | Tell us what property does every object in MS Access have? |
☺ | What are managing Data Tasks? |
☺ | Tell us how Do You Create An Append Query? |
☺ | Tell us About The Various Features Present In Ms Access? |
☺ | Tell us what format should my database be saved in to allow different versions of Microsoft Access to open the database? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |