Hello,
I have a db select field that I use which is built from a second relational table called Categories. This works fine when adding records. However when I go to modify existing records something doesn't quite work right - here's the scenario :
If I search for a record to modify and it is a direct hit (1 record) - no problem, in the Modify Record form the db select field is already properly selected.
However if I do a search to modify and come up with a multiple hit list and then check the record I wish to modify, in the Modify Record form all the existing fields for that record are filled in as they should be with the exception of the db select field - the pulldown list is on the default "---" and I must re-select the proper option then hit the modify record button. Any help would be greatly appreciated. Thank you.
easy does it
I have a db select field that I use which is built from a second relational table called Categories. This works fine when adding records. However when I go to modify existing records something doesn't quite work right - here's the scenario :
If I search for a record to modify and it is a direct hit (1 record) - no problem, in the Modify Record form the db select field is already properly selected.
However if I do a search to modify and come up with a multiple hit list and then check the record I wish to modify, in the Modify Record form all the existing fields for that record are filled in as they should be with the exception of the db select field - the pulldown list is on the default "---" and I must re-select the proper option then hit the modify record button. Any help would be greatly appreciated. Thank you.
easy does it