Parameter Query Report not working - why?

[Nino]

I'm attempting to limit my report to one record and so I based it off of a Parameter query (essentially I'm creating a Purchase Order). I used a single, but relational table in my query. When I go to build a report with the wizard, I start with my parameter query and then try to add fields from other tables (including the related one). When I do, I get an error message. When I create the report with just my parameter query, it works great, but I need the other fields for the report to be useful. If I create the parameter query with all of the fields I need it does not run properly. Additionally, I CAN create a report using my parameter query and one other table, but not the others I need. What am I doing wrong?

 

[Carol]

You will have to set up your recordsource for your report by making a query. Your query should include all the related tables that have the fields that you need to be in the report. Then you can have the report print off a selected purchase order by specifying a unique ID field, possibly the P/O number that relates to your main table. If you find that once you have made your query with the necessary fields and run it and it does not produce the results that you require then maybe you would have to go back and check your relationships and joins between the tables. All of your subtables required for your purchasing should relate somehow back to a main purchasing table. Report back if you still have problems.

 

[Nino]

Thanks for the response. You know... I tried to put all of the fields into my query, but it didn't work right. When I used just one table's fields it did work. I've played around with the relationships (even deleted them), but can't figure out the problem. I do have a unique number as the PO field and have made that field in a one-to-many relationship. The fact is - I stink at relationships (although that may be true in life as well I'm speaking of Access). Any tips regarding relationships? Is there a good reference book about them. My manuals are all too vague. Thanks!

 

[Carol]

In your query, start with your base table and add each table and run your query. If your query does not return any results with the joined table then I would suggest going into your relationships and deleting Referential Integrity on the join between the two or more tables that are giving your problems.
Report back if you require more assistance.

 

[Nino]

When I change the relationship to NOT enforce referencial integrity, I get no data. I have tried every combination I can think of.

 

[Carol]

Can you send a small sample? Should not be too hard to locate the problem.