I have a long questionaire devided into 7 tables. I have a main form and 7 subforms, with each table associated to a subform and a table associated with the main form. The tables each have a one to one relationship with the table for the main form linked by the Survey ID number (each table has the survey ID number as the primary key). When I type the Survey number into the main form it automatically appears on all 7 subforms but when I go back to the tables the other data is displayed but the Survey ID field contains no data. I hope someone can help!