Pending Clean Up
TOPICWhen Adding a SQL Request Control to a form only one field (column) will be returned. A potential work around is to add multiple SQL of controls.
INSTRUCTIONS1) Create the first SQL request control of display format text to query the primary key column of the desired record.
2) Create a Form variable of type string named after the primary column and connect it to the value returned by the first SQL action via a formula > = Named Controls <name of SQL control>
3) All proceeding SQL Request Controls should contain a select statement with the desired field and also include a where clause to include the primaryKeyField = <primaryKeyVariable>