Forum Discussion
CShewear
Dec 28, 2023Copper Contributor
Printing Customer Information from a Customer ID
I am setting up a database. I would like to know how I can print a customer name by just showing the customer ID. Is this possible? Thank you. CS
Tom_van_Stiphout
Dec 28, 2023Steel Contributor
Create a report query, joining the 3 tables. Then base your report on that query.
CShewear
Dec 28, 2023Copper Contributor
Thank you. I don't believe I have ever queried reports. But I will give it a shot. Thanks for the guidance.
- George_HepworthDec 28, 2023Silver Contributor
PMFJI: " I don't believe I have ever queried reports"
That's not what is happening.
What Tom is suggesting is a query based on the relevant tables.
That query then is used as a report's recordsource.
- CShewearDec 28, 2023Copper ContributorThank you for clarifying. I will see if I can do that.
Sincerely,
CS
- Tom_van_StiphoutDec 28, 2023Steel ContributorCheck out the aforementioned Northwind Starter Edition. You'll see qryrpt* queries, corresponding to rpt* reports.