Forms with Information from 3 tables

[Guest]

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

 

[Joseph Meehan]

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

I sounds like that third table is not updateable due to an issue with
the relationships.

 

[Guest]

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?

 

[Guest]

I should add that 3 of the 4 tables are linked from an external database.

 

[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

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]