Associating fields in a report

Ok, this may sound like a stupid question, but I was working on a report &
I'm not sure what I did but now I've lost field associations/control source.
I am displaying data from several different tables in my 'Detail' section,
but now I can only change my control source to one of the tables, leaving the
fields from the other tables showing errors (Field name not on list). I am
searching books & questions on here but can't seem to find an answer to the
simple question. Can anyone tell me what I 'broke' and how to fix it again?
I appreciate the help
--
Cheryl

Make sure the report's Record Source property contains fields from all the
required tables.

--
Duane Hookom
MS Access MVP
--

"Cheryl" wrote in message
...
Ok, this may sound like a stupid question, but I was working on a report &
I'm not sure what I did but now I've lost field associations/control
source.
I am displaying data from several different tables in my 'Detail' section,
but now I can only change my control source to one of the tables, leaving
the
fields from the other tables showing errors (Field name not on list). I
am
searching books & questions on here but can't seem to find an answer to
the
simple question. Can anyone tell me what I 'broke' and how to fix it
again?
I appreciate the help
--
Cheryl

When I check the Record Source (right click top left corner & select
properties right?) it lists all the tables. I'm looking at the data tab &
the all tab. If I click on a table (like the one that it can't find fields
for) in Record Source there, then it's like it finds all the fields on that
table instead & marks the other records (from other tables)as not on field
list. Then when I run the report, it asks for values for those fields also.
What did I 'break'?
--
Cheryl


"Duane Hookom" wrote:

Make sure the report's Record Source property contains fields from all the
required tables.

--
Duane Hookom
MS Access MVP
--

"Cheryl" wrote in message
...
Ok, this may sound like a stupid question, but I was working on a report &
I'm not sure what I did but now I've lost field associations/control
source.
I am displaying data from several different tables in my 'Detail' section,
but now I can only change my control source to one of the tables, leaving
the
fields from the other tables showing errors (Field name not on list). I
am
searching books & questions on here but can't seem to find an answer to
the
simple question. Can anyone tell me what I 'broke' and how to fix it
again?
I appreciate the help
--
Cheryl

You can create a query that selects fields from multiple related tables. Use
this query for your report's record source.

--
Duane Hookom
MS Access MVP


"Cheryl" wrote in message
...
When I check the Record Source (right click top left corner & select
properties right?) it lists all the tables. I'm looking at the data tab &
the all tab. If I click on a table (like the one that it can't find
fields
for) in Record Source there, then it's like it finds all the fields on
that
table instead & marks the other records (from other tables)as not on field
list. Then when I run the report, it asks for values for those fields
also.
What did I 'break'?
--
Cheryl


"Duane Hookom" wrote:

Make sure the report's Record Source property contains fields from all
the
required tables.

--
Duane Hookom
MS Access MVP
--

"Cheryl" wrote in message
...
Ok, this may sound like a stupid question, but I was working on a
report &
I'm not sure what I did but now I've lost field associations/control
source.
I am displaying data from several different tables in my 'Detail'
section,
but now I can only change my control source to one of the tables,
leaving
the
fields from the other tables showing errors (Field name not on list).
I
am
searching books & questions on here but can't seem to find an answer to
the
simple question. Can anyone tell me what I 'broke' and how to fix it
again?
I appreciate the help
--
Cheryl