Listbox won't display form values from another table

[rantan1618]

I had this working and I changed something and now i can’t get it work anymore.

Book Table

• Type INT
• Status INT

Type Table

• TypeID INT
  -Type name VARCHAR

Status Table

• StatusID INT
• Status name VARCHAR

I have a main table with a list of books, each book has a “type” and “status” field.
I had it setup so that i could select the value from a dropdown list and it was displaying the name not the ID. Because base makes you save constantly something got confused or I accidentally changed something and now it will either show a list of numbers, the IDs from the other tables, or nothing at all.
I have all the relations setup, everything seems to be right type and i know this was working before but now i cant get it to work anymore.
What am i doing wrong here?

[Villeroy]

Linked field: this form’s foreign key
Source type: SQL
Source: SELECT “Text”, “ID” FROM “Table” ORDER BY “TEXT”
Bound field: 1 (that is the second field with the other table’s primary key)