Tell us why has a relationship shown as 1:1 when I was expecting 1:∞?
Submitted by: MuhammadThis can occur if...:
...you are joining two primary keys. A 1:∞ relationship requires that one key only is a primary key. Check to see that you are joining the correct fields.
...you are joining a primary and a foreign key and the foreign key is specified as 'no duplicates' in the Index property for that field in the table.
(a) If the foreign key can have duplicate values in the table (this is the normal situation) then change the Index property to show this.
(b) If the foreign key really is a unique value in the table then check to see if you need to use a separate primary key for this table; perhaps you can use the primary key from the main table in both tables (as in point 1 above).
You should also check your design carefully. Sometimes a 1:1 relationship is correct (e.g. to save space in the database for information that that doesn't apply to all records, or to put sensitive data in a separate table in order to restrict access). But you need to be able to justify each 1:1 relationship that you have, so that you know that it is correct.
Submitted by: Muhammad
...you are joining two primary keys. A 1:∞ relationship requires that one key only is a primary key. Check to see that you are joining the correct fields.
...you are joining a primary and a foreign key and the foreign key is specified as 'no duplicates' in the Index property for that field in the table.
(a) If the foreign key can have duplicate values in the table (this is the normal situation) then change the Index property to show this.
(b) If the foreign key really is a unique value in the table then check to see if you need to use a separate primary key for this table; perhaps you can use the primary key from the main table in both tables (as in point 1 above).
You should also check your design carefully. Sometimes a 1:1 relationship is correct (e.g. to save space in the database for information that that doesn't apply to all records, or to put sensitive data in a separate table in order to restrict access). But you need to be able to justify each 1:1 relationship that you have, so that you know that it is correct.
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. |