Actually, I have many tables. All other table have one-to-many relationships to Table A. Only Table B does have a one-to-one relationship to Table A. Each table stores a type of medical information with a composite key ID+VISIT while Table A stores the patient's personal info with the primary key ID. If a patient is withdrawing from a clinical study, then he needs to provide some information, and since it doen't happen to all patients, I have this piece of information seperate from Table A and with the primary key ID; therefore, Table A and B has an one-to-one relationship.
Each form is designed to enter one type of medical information for one visit. For this withdrawn information, I have a query to select all fields from Table B and name and DateOfBirth from Table A with matching ID. I have only one form, no main/sub form, recordsource is the query, after entering the ID, I hope to see the name and DOB come up, so I know I enter the correct ID for this patient. I don't have any code since I don't know much about VBA.
Is this right to have both Table A and Table B? If I must have 2 tables with one-to-one relationship, how to solve this proble?
Your answer will be greatly appreciated!