Conditional value list too slow

[Mike Tubman]

Hello all,

I am running FM 19 cloud. Our local machines have FMP 19 on windows machines. 

For clarity reasons I may get wordy here and I apologize for that.

I have an estimating database for our cabling business with a parts table, an estimate table and and Estimate line item table. I have set up conditional value lists for the entry into the line items table. The first filed is the category field which has a straight value list (not conditional) and is populated with custom values (Fiber, Copper, Low voltage, Electrical etc.).

This tabs into the second field, which is manufacturer. This is conditional based on a relationship from the line item table to the part table (many to many, category = category, it's called eli_PRT_cat) so it only shows a list of manufacturers who have items for that category. 

This tabs into the third field which is part number. This list is based on a relationship from the eli_PRT_cat instance (many to one pk manufacturer = fk manufacturer) so it only pulls up parts from that manufacturer for that category. 

These value lists work, they pull up the values they should but they are INCREDIBLY slow. There are times that the lag is so long that the list doesn't even appear and you have to click out and back in for it to show up. My estimators are getting frustrated. It's been difficult to get them to use our new system and this isn't helping them. 

I am wondering what can be done to speed it up? I have removed all calculated values from the layout where they enter it and have adopted scripting to populate fields that were originally unstored calcs but it doesn't help. Also, it seems strange to me that going from category to manufacturer is significantly slower than going from manufacturer to part. My not so experienced brain tells me that maybe it takes time to establish the connection from the line item table to the part table but I am not sure. My test file which is local is instant but on the cloud is very much not. Maybe we just need a faster internet connection?

Any help would be greatly appreciated