How do I create a form using two tables?

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

Guest

I have two tables that I am trying to create a form off of. When I use the
form wizard and try to select the fields that I want from both tables, I'll
get an error on the form or I'll get a blank form (even though my tables have
information in them). I think the problem might be I'm not selecting the
right fields from each table. I have one table that has all of my
information in it and the other table is just a "notes" table if there are
any notes to appy to the the table.
 
A form can use only one recordset. You will need to create a query that
joins you table with information in it to the notes table and use this query
as your form's recordset. The problem you could run into is if there are
more than one notes record for an information record, this will not work
because it will create an uneditable record set.
If there are multiple notes record for one information record, you will need
to use a form/subform construct. Your main form should use theninformation
table as its recordset and the subform should use the notes table as its
recordset.
 
Thanks Klatuu -
Can you give me specific directions on how to do this? I've never worked
with subforms before. I believe I've created the subform correctly on the
main form but when I add a record to the subform and go back to the record
set, I don't see the information in the subform. i see it if I open up the
actual subform form but not actually in the record.

Thanks!
 
did you create a subform control on your main form? If not, then you need
to. then look at the properties of the subform control, not the sub form
itself. You need to set the linkage between the form and subform there.
 
I don't know - how can I check? When i created the subform I opened up the
main form, and then went into design view and selected the subform icon and
followed the wizard. I selected the table that I wanted to have in as the
subform and selected the field that linked the two tables together.

Thanks for all of the help!!
 
Back
Top