Linking form to multiple tables

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

This may sound a strange question - but I'm having a mental blockage.

I have one table which contains multiple questions and a second table that
contains multiple company names.

I need a method of displaying the questions on a form and being able to
store the responses - true/false - against a reference number obtained from
the table containing the company names.

From time to time the question will change - additions and deletions rather
than editing existing questions, this needs to be able to be tracked so the
original questions can be pulled up against the correct company.

Can someone suggest the best way of doing this.

Many thanks
Alex
 
Alex

It isn't clear from your description whether you table with "multiple
questions" has one record per question or one field/column per question. If
the latter, you have ... a spreadsheet!

More specific description of your data structure (it all starts with the
data!) may lead to more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff,

Table 1 contains several company details which at some stage will require
all the questions in table 2 to be completed. From time to time questions
will be added or deleted from table 2. I must have a facility to be able to
bring up the relevant questions that were relevant at the time so I need to
have a common field in both tables in order to make the connection.

I thought the easiest way was to have the list of questions in one table so
that additions and deletions could be made easier by accessing a table rather
than having to add fields to a form everytime.
 
Alex

It sounds to me like you have Companies, Questions, and
CompanyResponseToQuestion. This would take three tables, not two.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I had considered a third table but am struggling to decide exactly what the
best way is of displaying and saving the information I need.

I need it to be easy to update with additional questions in the future.
 
Back
Top