I have a question.

I finally got around the idea of having a dataset permanently open (desktop
databases) and went with this approach in my apps

1) User enters code
2) Transaction starts
3) Record is selected
4) User alters data
5) Record is posted
6) Transaction commits

Here is my query.
If I want to provide lookup comboboxes on that same form, surely it is
wasteful to select all records from the other table each time step (2) is
reached ? Is it better to have a permanently open transaction in the app
where these other records are already loaded ?

Pete