2. ASPRunnerPro General questions
  3. [SOLVED]  More field in the dropdown list
This topic is locked
[SOLVED]

 More field in the dropdown list

 		6/11/2007 7:05:22 AM
ASPRunnerPro General questions
I
 igiacchi author

So I have the table "Simple Articles" in the Add form I have a dropdown list that can permit to choose the suppliers of this article this dwopdown list it is linked to the suppliers table.

Eg:

SIMPLE_ARTICLE_TABLE
SA_ID

SA_S_ID_SUPPLIER

SA_DESCRIPTION

SA_PRICE
When I need to choose the suppliers I see the supplier name in the dropdownlist.
I have another table "Composed Articles" in this table I can Add using more dropdown list a max of 6 "Simple Artcles".

The problem occours when I choose an "Simple Article" I cant see the suppliers. This can make some cofusion in choosing the right Article to compose the Composed Articles using the Simple Articles.
COMPOSED_ARTICLE_TABLE
CA_ID

CA_DESCRIPTION

CA_PRICE

CA_SA_ID_1

CA_SAID...

CA_SA_ID_6
When I need to choose the Simple_Article I can see the Simple_Article but I need to see also the Supplier Name to be shure to choose the right Article.
There is a method to see listed in the dropdown list also the suppliers of each Simple Article, or an alternative solution to bypass my problem.
Thanks again
B
 		berkeleyjw 6/11/2007

If both fields you want to see are in the same table you can do this with a custom expression instead of selecting a specific field. "Custom Expression" should be an option in the "display field" field list. The syntax to concatanate will be different depending on your DB platform.
If the fields are in different tables then you can create a view on the DB back-end (have a key field, and then the displayed expression), and use this view to create the drop-down list.
Corinne 8/27/2007

If both fields you want to see are in the same table you can do this with a custom expression instead of selecting a specific field. "Custom Expression" should be an option in the "display field" field list. The syntax to concatanate will be different depending on your DB platform.

If the fields are in different tables then you can create a view on the DB back-end (have a key field, and then the displayed expression), and use this view to create the drop-down list.


Do you have an example of this? My database is SQL and the fields are in the same table.
Thanks!
paperhog 8/29/2007

Do you have an example of this? My database is SQL and the fields are in the same table.
Thanks!

[/quote]
I have the same question, I am using the same SQL platform and the fields are in the same table.
Thank you

Lori
paperhog 8/29/2007

Do you have an example of this? My database is SQL and the fields are in the same table.
Thanks!

[/quote]
Never Mind Found it right there when you select custom code the examples for sql, mysql and oracle are right there <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=20938&image=1&table=forumreplies' class='bbc_emoticon' alt=';)' /> Really COOL!
Lori