Lookup select box doesn't have values

[aaron_anderson]

I just created a new RP on the facilities_request table.

I have a field of type Lookup Select Box looking at the facilities_request table for the category field.

There are no options to select from the RP but there's about a dozen or so in the drop down list on the facilities request record. This is happening to me, as a system admin, so I doubt ACLs are playing a role here. I cleared the cache after completing the record producer but it's still showing an empty list.

Any thoughts?

[ccajohnson]

Most likely the category is found on a base table and not the facilities_request table. Check the field for Category on that table and see what table it resides on. You should be able to use that as your table to get the list of categories.

[Goran WitchDoc]

use a Select box instead like this:

I put the map to field as well since I guess you want to map the choice to the field in the record created.

//Göran