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?