column bindings

[Jon Rowlan]

Am I going mad ... I am sure that I have done this before ....

on a form I have a combo box.

For its datasource I have a simple query with 3 columns ...

customer name,
customer surname,
customer number

That is all that the Query returns

I have set column count to 3

and set bound column to 3.

But no matter what I do I cannot get this field to be set to the third
column entry when I select from the drop down ...

It will use the first and second column but no matter what I do I cannot get
it to be set to the third,

Limit to list = yes
I have tried Auto Expand as yes and no

Is it something to do with fact that the company number tends to be numeric?
Even though it is in a text field???

column widths are 2cm;2cm;2cm

They all display fine ...

Finally I have tried all the options with my on screen field bound to a
column on a table.

I am positive that I have had this working perfectly before ????

can anyone tell me what silly thing I am doing and put me out of my misery?

Many thanks all,

jON

 

[Al Campagna]

Jon,
Bind the combo to your CustNo field and try this setup...

Combo Cols = CustNo, CustName, CustSurname
Column Count = 3
Column Widths = 0"; 1.25"; 1.25"
List Width = 2.5"
Bound Column = 1

What this does is allow the user to only see the Name/Surname when selecting from the
combo, and when viewing the combo after selection...but really stores the CustNo in the
CustNo field.

 

[Jon Rowlan]

yep, that seems to have done the trick ...

I cant work out why I didn't get that before .... I must have tried every
combination ...

many thanks Al,

jON