custom dropbox

In the Query tab, set one of the field as alias:
SELECT

field_1,

field_2,

field_3,

field_4,

field_5,

field_5 as yes_no_dropdown

FROM table_name
In the Fields tab, enable the yes_no_dropdown only for add and edit pages.
In the Visual Editor set the yes_no_dropdown as "Lookup wizard". Choose the "List of values" option to enter manually the values.

I thought of using this as a solution prior to asking; however, I don't want a bunch of nonvalue added fields in my database. Thinking I might not have understood the capabilities of PHP Runner I tried what you suggested; however, I received an error because I used the same field with different alias.
Source: Microsoft OLE DB Provider for SQL Server

Description: Column name 'field4link' appears more than once in the result column list.
Is there a way to get around this that I'm not aware of?
I've used the field4link on the add page 3 times all with a different alias. The other fields in the add page are all being used and serve data collection purpose.

You don't need new non-values fields in the database, you are using aliases. Post the sql code.

There is no SQL code to post. I get the error when i click the Save button on the Add page.
And in the event section of the Add page nothing refers to the field4link datapoint.

Could you post the SQL code in the Query tab ?

SELECT

AEID,

QRID,

AEEngineer,

JobStatus,

AttachQuestion,

Drawings,

AEAttachment,

SystemTypes,

Reclaim,

ControllerType,

RequestedDueDate,

Ref_Label,

DateCreated,

DateAccepted,

RTransferDate,

OrigAEEngineer,

QRID_Num,

ControlType,

MonitoringType,

field4link AS link,

field4link AS AEDropdown,

field4link AS EngSpecial

FROM dbo.AE

I don't see the field4link field in the query. I see only the aliases for that field. Your query should be:

You have to unset the aliases before saving the record. Enter this code in the "Before record added" event before the return statement: