Hi, All!
I have a combo-box related question.
I am trying to pull in generic client data from a table into a form using a combo box, but I only get the option to pull in numeric data.
Here are the details:
First, I have 2 tables: ClientData and IncomeStatementData
The ClientData table is a static table lists all of our clients. It only changes if we get a new client or if a client updates their address/phone number etc. Each client has a Client_ID field (Primary Key) and each client is only listed once with information that will not change (Company_Name, Tax_ID, etc)
The IncomeStatementData table has income statement data for each company. We create a new entry for each company on a quarterly basis. This table also has Client_ID, Company_Name, Tax_ID, etc. The IncomeStatementTable has ID (autonumber) as its primary key.
There is a one-to-many relationship between the Client_ID in the ClientData table and Client_ID in the IncomeStatementData table.
I made form to input data into the IncomeStatementData table. In design view, I click Design >> Combo Box and then click where I want the combo box on the form.
I select "I want the combo box to get the values from another table or query" and click "Next"
Under "Which table or query should provide the values for your combo box?" I select ClientData (Because this is where the company name, tax ID etc is stored)
Here is where I am stuck. Where it says "Which fields of ClientData contain the values you want included in your combo box?" The only options are the numeric ones. Company_Name, for example, isn't available and neither are any of the other non-numeric fields (e.g. customer name, comments, preferred language, etc)
Thanks so much!
Justin