I have a project where there is a large number of 1_n relationships off of different fields from a core table. I am looking for a best practice to insert multiple records into the related table from the core table's edit form.
To oversimplify, lets consider a User table where there can be any number of phone numbers for the user. Each phone number is a simple text field, so the phone_number table is just [id, user_id, phone_number]. Obviously we don't know the phone numbers beforehand, so a drop down of existing values does not handle this situation.
What is the best practice for a user interface in adding these phone numbers through the grocery crud form? The best solution I can come up with is to pop up a fancybox, then refresh on close. This is unwieldly however, as in my project there will be multiple fields such as this, and there could be many entries in each field.
Perhaps I should step out of grocery crud and roll my own, but the deadline is short, as usual :). Any ideas for a clean, easy to use (from an end user perspective) system?
