Creating a Form (or Subforms) from 3 tables

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

Guest

Relatively new to Access. Have three tables, each with the same primary key
(a variable 's_no'). Have tried to use the form wizard (select each table
then "add all variable", but this does not work...
I want to create a data input form to populate the tables, but not sure what
is the best way to go about doing this. Can a create three forms, one for
each table and then somehow link them together for data input purposes?
Help!
 
Bijal said:
Relatively new to Access. Have three tables, each with the same primary key
(a variable 's_no'). Have tried to use the form wizard (select each table
then "add all variable", but this does not work...
I want to create a data input form to populate the tables, but not sure what
is the best way to go about doing this. Can a create three forms, one for
each table and then somehow link them together for data input purposes?
Help!
Click to expand...

Having three tables all with the same primary key field sounds like a deeply
dodgy design. Why not just one table?
 
I only created mutliple tables because there were too many variables to just
have one table...

A little background -- the source material for data entry is a survey.
Ultimately, I want responses to each survey to be one record in my dataset.
However, access seems to limit the number of variables you can have in one
table??
 
Bijal said:
I only created mutliple tables because there were too many variables to just
have one table...

A little background -- the source material for data entry is a survey.
Ultimately, I want responses to each survey to be one record in my dataset.
However, access seems to limit the number of variables you can have in one
table??
Click to expand...

255 fields is the maximum in one table.
 
Yep -- I am over that limit. Thus, is the best way to create ONE form for
data input to use a query or to use subforms with the 's_no' variable as the
linking key.
 
Bijal said:
Yep -- I am over that limit. Thus, is the best way to create ONE form for
data input to use a query or to use subforms with the 's_no' variable as the
linking key.
Click to expand...

Having a form bound to more than one table always causes problems. I'd go
for the subforms.
 
Back
Top