I see that there was an old topic in which someone had the same problem - listbox will not display list selections in the display field or transfer them to the supposedly linked field in the form’s main table. However, their problem was solved when they discovered that the two field datatypes were different. Mine are identical - text[varchar].
I’m using LO 7.1 on Windows 10.
Documentation is scattered and incomplete, so I’m missing something.
Please explain precisely how to set one up, starting with how the ‘linkage’ between list source table field and form linked field is established. What I did was:
- Start with a form linked to a table with text[varchar] field Text1. It is not a key of any kind. Does it need to be?
- I create a listbox, and fill in the form wizard. It correctly points to the list table, which has two fields:
ID (primary key integer)
textola (nonkey text field containing listbox entry text)
- I specify that Test1 and textola are linked. I have tried changing the Bound Field setting without luck, but I can’t figure out exactly what it does.
The listbox indeed contains all the entries from field textola, but won’t do anything with them when I select one.
Does there need to be a key relationship between Text1 and textola, or the ID primary key fields? The Wizard isn’t complaining that there isn’t.
Also, where’s the best place to go for such basic examples of Base useage, either in text or as sample databases? I managed to find one that shows how to put images into an Image Control, which was unexpectedly quite difficult-- it involved macros, and I never would have gotten it on my own. They’re hard to find just rattling around the 'Net. Examples really clarify discussion the best.
Thanks in advance.