Base Combobox Value and Display Text?

[Backalife]

Hello everyone,
I am a newbie to LibO Base and this is my very first post in the LibO Foundation Forum.
I am trying to use comboboxes on my forms the same way in Ms Access where you can have a Stored Value used in references and calculations and a Display value used to display the human readable text of the item, could someone please help me figure out how to implement a combobox displayng Names and storing ID’s in the background?
Thank you.

[Ratslinger]

Hello,

What you describe is a list box and not a combo box.

See on line help → Form Controls

and/or LO manuals → LibreOffice Base Guide Chapter 4 - Forms

There are many samples posted on this site. Here is one:

How to control listbox data

I have a listbox based on a table view ,tables address(id,GroupNumber,fname,… 20 records) and a lookup table (id,title 7 records). No matter which join I try Group ID(Lkup table) to GroupNumber(data table), when clicking the listbox I get All titles from the Address Table(Data tableT, 3/4 "Family2/3 Business, etc…? How can I control the list to only the values in the lookup Table(7). Tried changing field positions in the source view with no change. Any ideas ?

[Backalife]

Thanks for your help Ratslinger,
You are absolutly right, I just realized that the ListBox has two properties that make it to be a dropdown list as I wiched it to be, “Bound Field” under Data tab and “Drop Down” under General tab, I think It abvious that a new comer from Ms Access would easily fall in this missleading concept.
Thanks a lot sir & Best Regards.