I've tried to find a new way to use lookup tables. Now, I have a view for each lookup tables. It works fines but it's pretty slow each time I load a form. I used that method because it will be stored in a remote database.
Another way is to store all the information in arrays (properties in oApp). But I'm afraid that it will eat a lot of memory. Some lookup tables have 1000 records and I have about 40 lookup tables.
The last way I know is to make another LOCAL database and refresh it from the remote database (each day).
I am looking for new ways. Any help will be a lot appreciated.