P
Peter
Guest
Hi,
I am able to populate a drop-down menu with contents of a remote table, however I have hit a snag:
Using a foreign_key_field, the default menu option is always blank. Is there an option to force a default entry? The 'default' field only works for text boxes. This means you cant force a user to make an entry in a field.
If you use the select_options field, you automatically get the first entry as the default in your drop down, and this would be a better idea for the foreign_key_field, as you can always make the first remote-table entry blank if you want to give the user the option of a blank field.
Also, when you do a search, you have the opposite problem. IE you can leave a drop-down empty if you used the foreign_key_ field, but with the select_option you can only do this if you made the first entry in the select_options field blank (and this means the user would have been able to enter a blank field whilst inserting data).
Any comments/work arounds gratefully received.
Maybe some sort of field is required to allow/disable 'blank default on entry / blank default on search'? Or maybe extend the 'default' field to cover drop-downs, but split it into a default for 'inserts', and a default for 'searches'
Thanks for such a great program, its really really useful!!!
P.
I am able to populate a drop-down menu with contents of a remote table, however I have hit a snag:
Using a foreign_key_field, the default menu option is always blank. Is there an option to force a default entry? The 'default' field only works for text boxes. This means you cant force a user to make an entry in a field.
If you use the select_options field, you automatically get the first entry as the default in your drop down, and this would be a better idea for the foreign_key_field, as you can always make the first remote-table entry blank if you want to give the user the option of a blank field.
Also, when you do a search, you have the opposite problem. IE you can leave a drop-down empty if you used the foreign_key_ field, but with the select_option you can only do this if you made the first entry in the select_options field blank (and this means the user would have been able to enter a blank field whilst inserting data).
Any comments/work arounds gratefully received.
Maybe some sort of field is required to allow/disable 'blank default on entry / blank default on search'? Or maybe extend the 'default' field to cover drop-downs, but split it into a default for 'inserts', and a default for 'searches'
Thanks for such a great program, its really really useful!!!
P.