check entry into database as per listbox item only

asked 2017-11-16 09:15:10 +0200

koolninja gravatar image

i have table with item listed but during saving in LibreOffice base, i want only item saved related to item listed through save action button. can any have a good idea to deal with this

edit retag flag offensive close merge delete


Please describe in more detail: you're speaking of a (Base?) form? And you want to display some text (from a table column?), but store an index (related to the selected item?)

komma4 gravatar imagekomma4 ( 2017-11-16 09:28:06 +0200 )edit

Table name A have columns B, C. In B 1,2,3,4 entered and when data inserted in B and C then entry in only in B these listed 1,2,3,4 and C with reference to B .

koolninja gravatar imagekoolninja ( 2017-11-16 12:44:36 +0200 )edit

Neither this question nor this example is clear. What does the table contain initially, what values are entered into the form, and what is the desired result?

Jim K gravatar imageJim K ( 2017-11-16 14:09:42 +0200 )edit

sorry for inconvenience for poor input. I loaded material's list into a combo box in a form. When data saved of this form then only. i need data saved of form only when combo box item matched and reject saving when other then listed item

koolninja gravatar imagekoolninja ( 2017-11-20 09:24:50 +0200 )edit

Use a listbox instead

komma4 gravatar imagekomma4 ( 2017-11-20 10:37:43 +0200 )edit

how to convert combo-box to list-box with with same dropdown properties

koolninja gravatar imagekoolninja ( 2017-11-27 10:05:39 +0200 )edit

Edit mode > context menu of the control

komma4 gravatar imagekomma4 ( 2017-11-27 12:32:24 +0200 )edit

Thanks for this help

koolninja gravatar imagekoolninja ( 2017-11-29 09:12:49 +0200 )edit