We have a configurator where the sales person selects Make, Machine, Model, etc and then we lookup a whole bunch of specs from configurator lookup tables. It is noticeably slow, 20-30 seconds I would say. Is there any way to make it faster, or an alternative method that would be faster?
You can store those values in PcConData which has a much faster retrieval time. Depending on the version you are running there are improvements in PCLookup performance between 10.1.400 and 10.1.600
We are on 10.2.100.5 SaaS Multi-tenant. How do I use the PcConData ?
That changes things. I am not sure you would be able to take advantage of what I just mentioned. I have never been very clear on what can be done in the various cloud options.
I think I found the right window, but when I press the configurator button and hit search none of my configurators show up.
OK, I think I have created a row in the table, now how can I bind it to a combo box or reference it in a UD method?
For on-prem UD methods we reference the control data in a server method using code like this. Not sure you can do this in multi-tenant.
Erp.Tables.PcConData PcConData = (from PcConData_Row in Db.PcConData where PcConData_Row.Company == Context.CompanyID && PcConData_Row.PartNum == ConfigID1
&& PcConData_Row.Key1 == iInputName && PcConData_Row.SaveValue_c == iInputValue && PcConData_Row.InActive_c == false
select PcConData_Row).FirstOrDefault();Yeah, not allowed to do sever side code 
Also I can’t figure out how to make a BAQ like you have there. When I select an existing BAQ and do “Open with… Business Activity Query Entry” I get the error message “Menu ID SUMN1816 is not valid for the current user.”
Does that mean I have to get someone to give me more privaleges or does that mean the cloud version can’t do BAQ’s as well?
Ouch. Like I mentioned I don’t claim to understand the restrictions between the different options but just a guess, based on that error, you may not be able to, assuming you can access BAQs the standard way. You may want to reach out to your account manager and ask for a detailed walk-through of what can be done on multi-tenant and other cloud-based platforms. I would be interested in seeing that too 
OK, I got access to the BAQ entry screen now. I have another question now though. How can I change the column labels and order in PcConData?
Hi Evan,
On the Query Builder | Display Fields tab, you can change the order of the fields and the labels.
Mark W,
Hmm, but can I change the columns names and order in the table themselves? Number01 isn’t a very helpful name.
I’m afraid not Evan.