creating a form using fields from multiple tables

[Gremlin]

I have been trying to create a form for data entry utilizing 3 tables which I
have already established relationships for (one to many). when I want to
look at it in the "form" view, it just turns up blank. I then tried to
create a query for the three tables, but that didn't work either...any
thoughts?

 

[Brian Bastl]

Gremlin,

Your best approach would be to use subforms for the "Many" side. Perhaps
using a Tab Control.

Brian

 

[John Vinson]

I have been trying to create a form for data entry utilizing 3 tables which I
have already established relationships for (one to many). when I want to
look at it in the "form" view, it just turns up blank. I then tried to
create a query for the three tables, but that didn't work either...any
thoughts?

A Table can have only one recordsource; it can indeed be a query, but
it's rarely a good idea to even try to update two one-to-many
relationships using such a query - you'll get lots of duplicate
records (since every "one" side table record will be repeated as many
times as there are "many" side records in the two tables, MULTIPLIED).

Instead, use a Form based on the main table, with two Subforms - one
based on each related table.

John W. Vinson[MVP]