Bound Column property does not work for lookups with more fields

[nqobile]

Bound Column property does not work for lookups with more than one fields unless the others have column widths of 0cm.
What other property does one have to set to force the lookup to bind to any other stated field?

 

[LittleSmudge]

By 'lookups' do you mean "ComboBoxes" ?

If so, you can have any column you like as the bound column - and you can have some, one or fewer set to 0cm width.


What does your RowSource look like and which column are you wanting to BIND and which column do you want to display when the combo is closed up ?




G LS

 

[nqobile]

Thanks for the response Littlesmudge. May I elaborate on my problem. For example, my rowsource looks like this
'SELECT LUEntity.EntityID, LUEntity.Entity, LUEntity.Description
FROM LUEntity;'
The field that should be edited by this is a text field bound to LUEntity.Entity.
I also want the other 2 columns to show on the combobox = no columns are 0cm. Therefore column count is 3 and bound column is 2. What do u suggest??

 

[aaahhhrrggghhhh]

Hi.

Set Column Widths Property to : 0cm;1cm;2.5cm

Set Column Count to 3

Set Bound Column to 1 (as this is a unique key!!)

Hope this helps,
Mr Big. Dont be small. be BIG

 

[LittleSmudge]

What is the FORM ( that this appears on ) bound to ?

I think you are going to get some VERY strange results binding the combo box to a field in a table and having the same table provide the RowSource as well.
Without any additional protection you will be able to set the Entity field to any value that already exists in the table regardless of the value of EntityId.

Eg. If you started off with

EntityId   Entity   Description
   1        One       'The First'
   2        Two       'The Second'
   3        Three     'Third'
   4        Four      'Three Plus One'

You could then use the combo box alone to change the data to

EntityId   Entity   Description
   1        Two       'The First'
   2        Two       'The Second'
   3        Two       'Third'
   4        Two       'Three Plus One'

What is it that you are actually wanting to do ?

If it is a matter of 'seeing' the other two fields when you are editing the Entity field then there are far more secure ways of doing that.


'ope-that-'elps.

G LS