How would you define a one-to-one relationship between the primary table Supplier and the related table Product, then enforce referential integrity?
Database Tools tab/Relationships in the Relationship group/Show Table/Click Patient, Add button/Click Visit, Add/Close
A Show Table/Drag the PatientID field from the primary table to the related table, release button/Answer Yes to "create relationship?"/"X" to close
B Create tab/Relationships in the Relationship group/Show Table/Click Patient, Add button/Click Visit, Add button/Close Show Table/Drag the PatientID field from the primary table to the related table, release button
Database Tools tab/Relationships in the Relationship group/Show Table/Click Patient, Add button/Click Visit, Add button/Close Show Table/Drag the PatientID field from the primary table to the related table, release button/Make sure the PatientID field is listed for both tables in the Edit Relationships Window/Create/"X" to close