Question: How would you define a one - to - one relationship between the primary table Supplier and the related table Product, then enforce referential integrity?
How would you define a onetoone relationship between the primary table Supplier and the related table Product, then enforce
referential integrity?
Database Tools tabRelationships in the Relationship groupShow TableClick Patient, Add buttonClick Visit, AddClose
Show TableDrag the PatientID field from the primary table to the related table, release buttonAnswer Yes to "create
relationship?"X to close
Create tabRelationships in the Relationship groupShow TableClick Patient, Add buttonClick Visit, Add buttonClose Show
TableDrag the PatientID field from the primary table to the related table, release button
Database Tools tabRelationships in the Relationship groupShow TableClick Patient, Add buttonClick Visit, Add
buttonClose Show TableDrag the PatientID field from the primary table to the related table, release buttonMake sure the
PatientID field is listed for both tables in the Edit Relationships WindowCreateX to close
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
