Field as label

Scriptcase 8 Discussion
#1

for do it. I setup

  • the field as integer and in the
  • I Mark the Use lookup to display the field description[SIZE=12px]
  • I define the query : [/SIZE]SELECT cliente FROM T101Cliente WHERE id101 = {cliente101} ORDER BY cliente

[SIZE=12px]All work fine. But the field show the integer value and the value catch from the select.
Is there any way that the integer value isn’t showed ? .Only the value of the select.

Regards.[/SIZE]

#2

You can show a field for el Lookup: SELECT the_field_code, the_field_to_show FROM so you need set el field to show in your Select.:

SELECT cliente, DESCRIPCION FROM T101Cliente WHERE id101 = {cliente101} ORDER BY cliente

#3

Maybe I don’t explain well. In my example I try to show a field (which is integer)that instead that value, to catch from the lookup other value (from select). That it does well, pero It ever show the value of the integer and the value form the select (lookup).
So the field show : 1 Client John ( the first is the integer value and 2th is the value from lookup)
I want that the integer value isn’t showed.
Regards

#4

Afaik there’s an option when you create a lookup to show the key value. Have you set that checkbox by accident perhaps?

#5

This option only exist if you setup the field as Select, but I have it as integer, although I use tth “Grid Lookup” section to catch the value from a query

#6

Here’s what luis is asking:

Assume you have a table ‘people’ with autoincrement integer field of ‘id’ and text field ‘fullname’; another table, ‘appointments’ with field ‘personid’ foreign key.
Assume also people has one entry id ==> 1, fullname ==> ‘luis’

If you generate a form app on appointments and use automatic grid lookup on ‘personid’ and select ‘id’ as the key field and ‘fullname’ as the display field, when you run it you will see this displayed in the personid field:

‘1 luis’ instead of just ‘luis’.

I think this is a bug because it doesn’t happen with grid apps.

The clumsy workaround is to create another text field that’s not stored in the database and initialize it with the grid lookup SQL code.