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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only