Unable to Select Item from Combo Box

[usachrisk]

Hello,

I have a table in my database that I'm having an issue with. Basically, there are two tables that relate to each other as follows:

I have a table called AccountNumbers with the following fields:

CostCenter - Text(6)
Vendor1Acct - Text(11)
Vendor2Acct - Text(11)
Flag - Text(255)

and I also have a table called PagerList with a bunch of fields, but the most important to this issue is one field called "CompanyCostCenter". This field was designed as a combo box in the table with a lookup pointing to AccountNumbers, so when I'm in the table, I drop down the combo box and select the costcenter from the list, which has the two Vendor account numbers next to it.

My problem is that some of them are "unselectable". They don't differ in any way I can see from the others, but some of them when I select just automatically push me to the one above it. I can't change ANY records to these specific cost centers, either directly from the table, or from an adhoc form I built around it.

I don't have any validation rules or such craziness -- any other reason this might happen?

If I didn't dedicate so much time already to building everything around these columns, I'd just drop the lookup field altogether, but that's not an option now :-(

 

[cogent1]

This sounds like an issue of udatability,ie relationships.

Please explain how your tables are joined and how youy populate your combo

 

[usachrisk]

Hello -

I have no relationships in my table and the only way that these two tables are connected is like I explained in that the PagersList table uses the accountnumbers table in a lookup on the CostCenter column.

Christopher.

 

[Pat Hartman]

Sounds like CostCenter is not unique.

 

[usachrisk]

Hi Pat -

I figured it out and you were 1/2 right -- costcenter was unique which was what was throwing me for loops -- but my damn BoundColumn was set to 2, which is Vendor1 which, although normally unique, was not in some cases because some of them were N/A. I'm not sure how BoundColumn got set to 2, but changing it fixed me right up.

Thanks a bunch!
Christopher.