Input multiple tables into a form

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

Guest

I am trying to insert 2 different tables into a form. Instead of having one LONG table that saves the data of my form I want to break it down into sub menues. Problem is when i specify the controll source there is only the table feilds for one table. Basically what I believe I need to do is create a relationship between the 2 tables. How do I do that?
 
Create a query that uses both tables, and join them on the appropriate
fields. Then use the query as the recordsource for the form.

--
Ken Snell
<MS ACCESS MVP>

Robert Powell said:
I am trying to insert 2 different tables into a form. Instead of having
Click to expand...
one LONG table that saves the data of my form I want to break it down into
sub menues. Problem is when i specify the controll source there is only the
table feilds for one table. Basically what I believe I need to do is create
a relationship between the 2 tables. How do I do that?
 
Back
Top