A small puzzle....
When creating/updating a record which is the child of another table, it is sometimes necessary for the user to select the particular parent record. If there is a relatively small number of records to choose from (e.g. <<200) then a valuelist and dropdown usually suffices just fine
But in the case where the parent table has a relatively large number of records (e.g. >>1000) this approach doen't scale well (nor is it too user-friendly)
Any suggestions on how to approach this?
Ideally I'd like to be able to call a method/whatever as a subroutine and have the user rummage around in a pop-up search screen, review the results, possibly re-do the search and finally either select a record and return or just cancel - in either case returning to the screen they started with. But I can't see how to do this in Servoy (last time I tried, I could get a search screen in a pop-up but subsequent screens appeared in the main window).
Thanks,
Neale.