display linked field in table automatically

[Guest]

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!

 

[Pat Hartman\(MVP\)]

Before you go any further, you need to rethink your application. You are
committing "spreadsheet" as others say. You need to remove your spreadsheet
hat and put on your relational database hat. The course you are taking will
become a nightmare if it isn't already. It is IMPERATIVE that you normalize
your tables. A few months ago there was a two-part article written by a
member of the MS Access development team that explained what a
survey/questionnaire database ought to look like. The article was published
in Access Advisor which I think is now called "Advisor Guide to Microsoft
Access". You should be able to find it by searching the advisor.com
website. You may have to subscribe to read it. You can also search here
for links to other examples.