2. ASPRunnerPro General questions
  3. Combo box on Edit page?
This topic is locked

Combo box on Edit page?

 		1/9/2008 3:32:47 PM
ASPRunnerPro General questions
R
 riceman0 author

Hi, so far ASP runner is great, but wondering if it has the following capability:
I have two related tables, let's call them Documents and Engineers. One field in Documents is Author ID, which contains a number that points to the primary key ID of the Engineers table. Can I make it so that when the user is on the "Edit" page of a Document record, he/she is presented with a combo or list box of employee names to select from?
I can't seem to find the combination of settings that provide this result. Thanks in advance!
R
 		riceman0 author 1/10/2008

I take it this is not possible?
J
 		Jane 1/11/2008

Hi,
to setup field as dropdown box on the add/edit page proceed to the Visual Editor ta, choose Lookup wizard option on the "Edit as" settings dialog and select link table, link and display fields.

To open "Edit as" settings dialog double click on the field.
500418 8/4/2008

Jane

but how do you combine 2 fields? into 1 combo box?
J
 		Jane 8/5/2008

Hi,
to combine two field select custom expression in the Display field dropdown on the "Edit as" settings dialog and concat two or more fields in this expression.
500419 8/5/2008

Hi,

to combine two field select custom expression in the Display field dropdown on the "Edit as" settings dialog and concat two or more fields in this expression.


I just want independent items in a drop down list so what would be the mysql sytax? I tried concat(Plans_1,' ',Plans_2) and it put them together in one expression
J
 		Jane 8/6/2008

Hi,



concat(FieldName1,' ',FieldName2) is the correct syntax.
500420 8/6/2008

Hi,



concat(FieldName1,' ',FieldName2) is the correct syntax.


BUT THAT COMBINES THE FIELD INFO.
I WANT 5 SEPARATE FIELDS LISTED

PLAN_A

PLAN_B

PLAN_C

ECT
AND YOU CAN SELECT ONE.