Good afternoon,
Now I'm not sure whether this probelm is with my report or in my query, so I am posting in both areas.
On a form in my database I've included a look-up field that reference data from anoher table (i.e. the main data on the form comes from one table, and the "look-up" reference information on the form comes from another table). In preparing a report to show the main table data and the look-up information, I've created a query that includes the relevant fields of both tables that are related by the Unique ID [autonumber] field.
My report pulls its information from this query, but the look-up data does not correlate with the main data. What I mean is that while record #1 of the main table might reference record #5 of the look-up table on my form, what actually appears in my report for record #1 of the main table is record #12 of the look-up tale instead.
Does that make sense? In other words, I can't get the main table records to match up with their corresponding look-up table records on my report, eventhough they match up perfectly on the form.
What am I doing wrong? Is there a problem with the query?
Thanks in advance.
Earl
Now I'm not sure whether this probelm is with my report or in my query, so I am posting in both areas.
On a form in my database I've included a look-up field that reference data from anoher table (i.e. the main data on the form comes from one table, and the "look-up" reference information on the form comes from another table). In preparing a report to show the main table data and the look-up information, I've created a query that includes the relevant fields of both tables that are related by the Unique ID [autonumber] field.
My report pulls its information from this query, but the look-up data does not correlate with the main data. What I mean is that while record #1 of the main table might reference record #5 of the look-up table on my form, what actually appears in my report for record #1 of the main table is record #12 of the look-up tale instead.
Does that make sense? In other words, I can't get the main table records to match up with their corresponding look-up table records on my report, eventhough they match up perfectly on the form.
What am I doing wrong? Is there a problem with the query?
Thanks in advance.
Earl
