Hello,
I have a table of customers with simple short text fields throughout. I have then created another table where I refer to the customer table in a combo box. I used the lookup option when creating the table which then led me off to choose the customer table and sort the names etc. So in my new table/form I have a nice drop down box where I can choose my customer from a list. This is all ok, however I am running into a problem on other forms where I'm trying to search for a customer and the result is a number.
I've read a lot about making the field types match etc but how do i manage that if the customer name in the table is text and then the lookup reverts to a number. I feel like i am going round in circles with this one and any help would be appreciated. Hope it makes sense too. Thanks.
I have a table of customers with simple short text fields throughout. I have then created another table where I refer to the customer table in a combo box. I used the lookup option when creating the table which then led me off to choose the customer table and sort the names etc. So in my new table/form I have a nice drop down box where I can choose my customer from a list. This is all ok, however I am running into a problem on other forms where I'm trying to search for a customer and the result is a number.
I've read a lot about making the field types match etc but how do i manage that if the customer name in the table is text and then the lookup reverts to a number. I feel like i am going round in circles with this one and any help would be appreciated. Hope it makes sense too. Thanks.