scain101

Thanks to both of you for that information. After reading the referenced information and using Daniel Woods' custom function, I renamed the TO for Proposals and the statement worked.

I need some help with ExecuteSQL. I have a TO “Sales” that is related to Estimates, Inspections, and Proposals via ID_SALES:id_sales. I created some simple ExecuteSQL calculations that work on Estimates and Inspections, but the same calculations will not work with the related Proposals TO. · I know that the relationship is good because I can get the SUM and COUNT from Proposals with a basic calculation (not ExecuteSQL). · I know there is not a problem with the name on the related Proposals TO (like a space between words). I've copied and pasted the working calculations and I have started from scratch, and neither works. This statement works: ExecuteSQL ( "SELECT COUNT (ID_ESTIMATES) FROM TO40_ESTIMATES WHERE ID_SALES = ? “ ; "" ; "" ; TO13_sales_ESTIMATES||id_sales::id_sales ) --- This statement does not work: ExecuteSQL ( " SELECT COUNT (ID_PROPOSAL) FROM TO26_PROPOSALS WHERE ID_SALES = ? "; "" ; "" ; TO13_sales_PROPOSALS||id_sales::id_sales) Any help would be appreciated. SC

Thank you very much bcooney. That was exactly what I needed.

I have a layout with two buttons on it. Button 1 simply sets the variable for the chosen Section [$id_section; Value:TO1a_sites_SECTIONS] Button 2 runs the "Resume Script" command I'm trying to define a calculation in the Inspector's "Hide Object When" calculation so that Button 2 only appears after the variable is set. So far no luck and any help would be appreciated.