How to use first column of combobox from table in query?

[jaryszek]

Hi guys,

I have table "tbl_MapaZus" with Combobox with PrzyczynaOutput field:




"tbl_MapaZus" is mapping table.



Now i am using this table to update data form Excel link table with using query:



If i want to update field "Cause" in "tb_Main" query like in attachment is working fine.
Problem is that field Cause is a text string and i need to have number corresponded to it.

So i would like to update also CAUSE_ID_FK in "tb_Main" using first column in combobox in "tbl_MapaZus".
Please see the attachment - query here is not working:



It is possible to refer to table combobox specific column using query ?

Please help,
Jacek Antek

[June7]

No. Query will not recognize the Column property at all. Doesn't matter if reference is to lookup field or to combobox on form. Structure combobox so the ID is in first column and set ColumnWidths property to hide the ID column and set BoundColumn to 1. This will make value of the combobox the ID but display the descriptive field.

[jaryszek]

Thank you very much June7!

I did that so i am hiding this value within combobox.
But after updating Cause field in "tb_Main" even if Cause field is a combobox only text is updated (visible column not hided).

Maybe i should add third column to "tbl_MapaZUS" which will be automatically inputed when Cause ID will be choosen by User?
After taht i can update "tb_Main" with my created column...?

Best Wishes,
Jacek

[jaryszek]

a sorry my mistake this is working !!!

Thank you very much!
Best Wishes,
Jacek