Forum Discussion
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
Thank you for answering. The customer ID is entered by the data entry person. I am trying to put together a feasibility conference appointment database. The previous database had one gigantic table where all the information was added. I was trying to shorten it by adding only the customer ID and Facility ID. numbers. But my quandary now is how can i get the table below to print out the customer ID and facility information.
I have the following fields in my table:
Feasibility ID Customer ID License # Inspector Date Time Status
Thank you,
CS
I have the following fields in my table:
Feasibility ID Customer ID License # Inspector Date Time Status
Thank you,
CS
> Feasibility ID Customer ID License # Inspector Date Time Status
I would HIGHLY recommend you get rid of spaces and other funny characters, as well as Reserved Words.
Also a few more lookup tables may be in order, like tblInspectors and tblStatus.
FeasibilityID, CustomerID, LicenseNo, InspectorID, VisitDateTime, StatusID
- I do have look up tables for each of the items listed.
Thanks,
CS- Create a report query, joining the 3 tables. Then base your report on that query.
- Thank you. I don't believe I have ever queried reports. But I will give it a shot. Thanks for the guidance.