How to display of the description of a related field?

boby

Hello,
I'm a newbie in RTC, and I try to display the value of a field related to anoher table..
For example, in the item card, the payment method is "1", which is the code corresponding to "bank transfer" in the payment method table.. And I'd like to display "bank transfer" in place of (or beside) "1" in the item card..
Can you give me some tricks to do that??

Thanks for reading ;-)

Andwian

Table Item
Payment Method - OnValidate
recPaymentMethod.GET(recItem."Payment Method");
label."Payment Description" := recPaymentMethod."Description";

ufuk

To display it on RTC you have to add a new item on Page Designer having SourceExpr PaymentMethod.Description and get the value on Product Group Code - OnValidate() as:

IF NOT PaymentMethod.GET("Payment Method") THEN
  PaymentMethod.INIT;

boby

Thank you very much for your answers, but I've tried to put in the onaftervalidate of a custom field in the item table, the "label.field:=" causes a compilation error (undefined variable "label")..
What Am I doing wrong?


PS: I miss my old "classic" client ;-)

Andwian

What is the design of yours? How do you want the Payment Method Description arise? Where? in any field or just label (I am sorry, I meant Textbox?), and when do you suppose it will be filled?

Andwian

Are you sure it is Item Card? Not the Customer or Vendor card?
Just curious why there is such Payment Method field in Item Card (or maybe just in your localization)

boby

Hello,
Thank you for your interest.
In fact, I'm wrong in my example :oops: . I've created a table Colors, and added a field color in the item table. In the color table, I've a field code (related to another system, so I can't rename it) and a field description. I'd like to display the description of the color (blue, red...) and not the code (which make the link, but is 001,002,003)..
I hope I've made it more easy to understand.
I guess I've to work in the Page, not in the Table..

Thanks again for your advices
Boby

Andwian

If understand you:
1. There is a new field in Item table:
a. Color Code
b. Color Description
2. I think you want the Color Description in Item table is updated when you fill the Color Code

If so:
1. Design Item table
2. Add code in Color Code - OnValidate:

recColor.GET(recItem."Color Code");
"Color Description" := recColor."Description";

3. This way, the Color Description in Item table will be populated when you input the Color Code
4. This way too, you will see it on the Item page, since the information (record) to display in page are now available from it's table 8)

boby

Thank you for your advice..
I don't want to repeat the field already present in a separate table "color".. The item table is already very heavy (>10000 items) and the color description is quite long (250 characters)..
Any other idea?

Andwian

boby wrote:

I don't want to repeat the field already present in a separate table "color".. The item table is already very heavy (>10000 items) and the color description is quite long (250 characters)..
Any other idea?

What is your idea then?

ufuk

If you do not want description field to be exist in your table, then just use a variable as I mentioned before and add it to the appropriate place in Page Designer.