Solved Data from Combobox on listbox (1 Viewer)

Rania01

Member
Local time
Today, 11:24
Joined
Oct 9, 2021
Messages
59
Dear All,

How to show the data from combobox on listbox

Example Combobox

1 Afgehandeld
2 Ingediend

on my database listbox showing 1 instead op Afgehandeld

Please help how
 

Attachments

  • Listbox.png
    Listbox.png
    81.2 KB · Views: 133

MajP

You've got your good things, and you've got mine.
Local time
Today, 06:24
Joined
May 21, 2018
Messages
8,463
The query that forms your listbox needs to include a join to those other tables where StatusID has a descriptive name.
 

Rania01

Member
Local time
Today, 11:24
Joined
Oct 9, 2021
Messages
59
The query that forms your listbox needs to include a join to those other tables where StatusID has a descriptive name.
Dear MajP,

i get error see attach the file
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 06:24
Joined
May 21, 2018
Messages
8,463
tblStatus should not have a KlantID
In tblKlant the StatusID should be numeric not short text
I would call Status in tblKlant StatusID_FK
You now have two fields called Status in two tables with different meaning. In the Status table Status is the description. In the Klant table Status is the ID. Very confusing.

My naming Convention Always.
StatusID
StatusDescription

in the foreign table
StatusID_FK
 

Users who are viewing this thread

Top Bottom