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

How are you showing the Customer ID? Where does it come from (a table? user data entry?)It is more common that a customer is chosen from a dropdown on a form: it has 2 columns: an invisible CustomerID, and a visible CustomerName column. If you download the Northwind Starter Edition Template (File > New), you will see an example of that on the OrderDetails form.

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 StatusThank you,CS

Good for you following relational database principles, where everything has 1 place only.If we are on a Feasibility form, and selected a Customer from the dropdown, we have several options on getting additional customer info to display on the screen. The simplest may be to have the combobox (name: cboCustomer) have more than 2 columns. Example RowSource:select CustomerID, CustomerName, City, CreditLevel from tblCustomers order by CustomerNameThe columnWidths for the combobox are set to 0;1;0;0. Of course ColumnCount is now 4.Add a textbox to frmFeasibility and set its ControlSource to:=cboCustomer.Column(2)and another one for Column(3). This will display the City and CreditLevel.

> Feasibility ID Customer ID License # Inspector Date Time StatusI 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

Printing Customer Information from a Customer ID

Tom_van_Stiphout
Steel Contributor
Dec 28, 2023
How are you showing the Customer ID? Where does it come from (a table? user data entry?)

It is more common that a customer is chosen from a dropdown on a form: it has 2 columns: an invisible CustomerID, and a visible CustomerName column. If you download the Northwind Starter Edition Template (File > New), you will see an example of that on the OrderDetails form.
- CShewear
  Copper Contributor
  Dec 28, 2023
  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
  - Tom_van_Stiphout
    Steel Contributor
    Dec 28, 2023
    > 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

Forum Discussion

Printing Customer Information from a Customer ID

Share

Resources