Pass thru table

belsha

Registered User.
Local time
Yesterday, 19:27
Joined
Jul 5, 2002
Messages
115
I have 3 tables, Patient, Preg, Visits. Estab relationships bet Patient and Preg (1 to M) and Preg to Visits (1 to M). I have created a table with the primary keys concatenated in Patient and Visits, done a make table query with the existing Pat and Preg tables, and created relationships with this table, patient, and pregnancy. Question is, how do I get new info into the table with the concatenated key? Patient table now has the prim key as control for frmPatient, and Visits now has the prim key as control for subfrmVisits. Is there a way to have the ID field dump into the concateated table from the Patient table, and from the Visit table when entered by the user?
 
The table you built is called a linking table. Build your form off the linking table using combo boxes and/or list boxes to fil in the inforamtion you need. If you need to add a new patient then you pop up a secondary from that allows entry of theat info. when you close the secondary form it will be available in the combo or list.

Good Luck
 

Users who are viewing this thread

Back
Top Bottom