Forms with Information from 3 tables

G

Glenda

I have 3 tables in my database. I would like the form to 'automatically'
fill-in information on the form from these 3 tables. I have tried and it
works for the first 2 tables, but when I add in the 3rd table, it's as if the
form is no longer a form, but a report - the form will not accept any input.
Is there any way around this?
Thanks, Glenda
 
G

Glenda

Actually there are 4 tables. The 4th table dioes not have the field that
tables 1,2, and 3 are linked on. The 4th table llinks to the 3rd table with
a field common to these tables. The 3rd table relates (with a different
field) back to the main and 2nd table. Is this a no-no?
 
J

John Vinson

I have 3 tables in my database. I would like the form to 'automatically'
fill-in information on the form from these 3 tables. I have tried and it
works for the first 2 tables, but when I add in the 3rd table, it's as if the
form is no longer a form, but a report - the form will not accept any input.
Is there any way around this?
Thanks, Glenda
Click to expand...

Use a Form with Subforms; base a main Form on the "one" side table,
and a subform on each of the child tables. You can put a subform on
one of the subforms for the fourth table that you mention downthread -
you'll need to make the subform Single Form view rather than
continuous or (the default) datasheet view, though.

John W. Vinson[MVP]
 
Top