/table/add form confusing with labels and foreign keys about dancer-plugin-simplecrud HOT 2 OPEN

Is this still valid?

Testing the example app, which uses foreign_keys for the employer_id column, it displays the name as employer_id, and gives me the available employer records to select from.

from dancer-plugin-simplecrud.

I see what this is about. I've worked up a branch to illustrate this:

https://github.com/joshrabinowitz/SimpleCRUDTest/compare/foreign-key-labels-gh-75?expand=1

The issue is if you have interfaces like this:

simple_crud(
    record_title=>'thing',
    prefix=> '/things',
    db_table=>'things',
    foreign_keys => { category_id => { table=>'categories', key_column=>'id', label_column=>'name' }},
    labels => { category_id=>"Category" },
);
simple_crud(
    record_title=>'category',
    prefix=> '/categories',
    db_table=>'categories',
);

and you have two tables like this, but with no data:

create table things ( id int PRIMARY KEY AUTO_INCREMENT, name varchar(255), category_id int);
create table categories ( id int PRIMARY KEY AUTO_INCREMENT, name varchar(255) );

Then when you go the /things/add form, there will be two text boxes present, one for the "name' and one for the 'category' (instead of the radiobuttons to chose one of the categories - which here don't exist).

I guess the right thing is to give the user an error message that there are no 'category' records to refer the foreign_key to?

from dancer-plugin-simplecrud.