Creating a Form with 2 Tables

[Task Database Nightmare]

I am trying to create a Form using two Tables. Because each Table has many
Fields, I am unable to create a Query to link the two Tables. I was going to
create the Query to use as my source for the Form.

Is there a way to create a Form using two Tables?

Please advise - thanks!

 

[Golfinray]

You can create a form with one table and a subform with the other if they
have a common element that will link them. Usually, you would use a project
number or something in common with both tables to link. Let the subform
wizard build the subform for you and it will ask you what you want to link
on. Another possibility is a union query, but that can be a little difficult.

 

[John W. Vinson]

I am trying to create a Form using two Tables. Because each Table has many
Fields, I am unable to create a Query to link the two Tables. I was going to
create the Query to use as my source for the Form.

Is there a way to create a Form using two Tables?

Please advise - thanks!

How are the tables related? If you have more than 255 fields in all... your
tables are almost surely not correctly normalized. I suspect the problem lies
in your table design not the form design! I've had to use as many as 60 fields
in a table... once, protesting violently all the way.

That said... if the two tables are in a one-to-many or one-to-one relationship
you can use a Form based on one table, with a Subform based on the other,
using the linking field from the relationship as the master/child link field
of the subform control.