check table creation steps

[Former Member]

I need to provide f4 help for two fileds on a screen

Can I use a single check table to provide F4 help for both the fields.

My tw0 field values sizes are bigger in size thats why I want to create check

tables otherwise I would directly use value assignment in domain.

my two fileds are

1 Performance rate which has 5 values like 1.00 - 2.00(size is 11 chars)

2 Performance rate description has 5 values like XXXXXXXXXXXXXXXXXXXXXXX

Please provide me every step in creating check table

Thanks

Raj

[former_member195698]

Create a single table with two fields

a) Performance rate (Key)

b) Performance rate description

For the first field in the screen you can use this table as check table. (Declare the field with reference to the check table field)

For the second field -- Why do you want to provide a F4 help for this field?

Since the Description can be picked from the check table based on the selected "Performance rate", you can just grey out the second field.

You can just populate it automatically based on the "Performance rate" selected in the first field.

Regards,

Aj

[Former Member]

Hi,

In order to create check table first select the field of the table on which u want to F4 help.

Then click on foreign keys tab which is nearby srch help.

Then enter the name of table from which u want the values in check table column.

Then click copy.

Same way repeat the process for second field.

I hope this will help u solve ur problem.

Regards

Payal

[Former Member]

I created check table but it is saying enter valid value when creating records for check table