stumped

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have form where I have a drop down box that lets the user select a
customer. I'm now trying to write a query where this filed is joined to my
customer table and pulls out the address for that customer. I have the
tables joined, but it is not seeing the fields as identical. I think what
is happening is that the combo box, while it has the "index #" column as "0",
is not seeing the 2 fields in the 2 tables as equal. I could be wrong of
course. I can not join the field from my main table to the "index #" field
because they are different "data type". SOmething tells me this is easy, but
it has me stumped.

thanks in advance for help
 
That was very helpful. However, it didn't fix the problem. I can get the
combo box to list the customers. What isn't working is once that customer is
selected for the query to go to another table, match that customer name to
the customer in that table and pull out the address. Does that make sense?

thanks again
 
Just a thought =

I haven't tried it, but would using the LIKE functionality/operator in the
query be a viable option?
 
Make sure the *Bound* Column of the ComboBox is the Column that has a value
that uniquely identifies the Customer, i.e. CustomerID Field. This way, the
value of the ComboBox is the CustomerID and you can use the ComboBox (value)
as the Parameter for the Query you are trying to create.
 
When I select the field "Customer" from Table1 I have it looking up from the
"Customer" Table. SELECT [Customers].[Index #], [Customers].[Customer] FROM
[Customers]. I have it bound to Column 1. I have Customers from Table1 and
Customer from Customers table joined. If I try to have customers in Table 1
bound to column 0 adn then join Customers from Table 1 to Index # in Customer
table I get a type mismatch. Still not sure where I'm going wrong. I know
this should be simple.

thanks again
 
ok, figured it out... Customers in the Table1 was a text field. Changed it
to a number then it joined to the Index #. Bingo... it all worked.

thanks to all for your replies.
--
aj


AJ said:
When I select the field "Customer" from Table1 I have it looking up from the
"Customer" Table. SELECT [Customers].[Index #], [Customers].[Customer] FROM
[Customers]. I have it bound to Column 1. I have Customers from Table1 and
Customer from Customers table joined. If I try to have customers in Table 1
bound to column 0 adn then join Customers from Table 1 to Index # in Customer
table I get a type mismatch. Still not sure where I'm going wrong. I know
this should be simple.

thanks again


--
aj


Van T. Dinh said:
Make sure the *Bound* Column of the ComboBox is the Column that has a value
that uniquely identifies the Customer, i.e. CustomerID Field. This way, the
value of the ComboBox is the CustomerID and you can use the ComboBox (value)
as the Parameter for the Query you are trying to create.
Click to expand...
Click to expand...
 
Back
Top