Can a form have two record sources?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have contructed a database for questionnaire purposes, which is based on
two tables and two forms. Each form is linked to the relevant table.
My problem/question is can a form be based on two record sources? (i.e. two
tables). So far we have found that when inputting data we might accidently
input the data on a wrong record. In order to avoid this we simply want to
have one form - that is based on our two tables. Is this achievable?

Thank you in advance for your help.

Katerina
 
Katerina said:
I have contructed a database for questionnaire purposes, which is
based on two tables and two forms. Each form is linked to the
relevant table.
My problem/question is can a form be based on two record sources?
(i.e. two tables). So far we have found that when inputting data we
might accidently input the data on a wrong record. In order to avoid
this we simply want to have one form - that is based on our two
tables. Is this achievable?
Click to expand...

Use a form with a subform.
 
Back
Top