December 6, 201015 yr My Setup: Orders layout based on Orders table. Portal on orders layout based on OrderLines table. OrderLines table stores fields: OrderLineID, ItemID, Price. Item table stores fields: ItemID, ItemName. If each orderline in the portal displays only the OrderLineID and the ItemID (both fields in the orderlines table). This works well and is fast. Since I want to display the ItemName instead of the ItemID, I am using a pop-up menu style control with a value list based on the Item table. The value list is set to use values from the Item table with ItemID as the first field and also display values from a second field, but only show values from the second field. This way, the portal shows the OrderLineID and the ItemName, which is what I want. However, this slows portal scrolling greatly. It also slows the Orders layout when browsing through order records. There is about a 1 sec delay in scrolling in the portal and about a 2 second delay when browsing through order records. All of the fields involved are indexed. This seems like too much of a slowdown to be acceptable. I am using FM11 Pro Advanced. So... 1. Is this kind of slowdown typical? It seems to me that this would be a very common use of value lists. 2. Is the slowdown due to indexing of fields? Should I NOT index certain fields? 3. Are there faster ways to do the same thing? Thanks! Paul
Create an account or sign in to comment