Doesn't understand in using table relation

mark_christs

Dear All,
I am creating two fields and first field related to second field.
The first field type is option consists of item and service. The second field type is code and I am using
table relation in the second field properties table and I wrote there as follows:
1st condition in the first line of table relation
Condition :work condition=FILTER(Item)
Table : item
Field : no

2nd condition
Condition :work condition=FILTER(Service)
Table : Service Item Line
Field : service item no.

But after I did and trying to run, there was an error said "the field below must be included in the table's primary key.
field : service item no. and table : service item line" when I select second option of the first field and trying to field the second field using service item list.
Any help will be appreciated so much.


rgds,
Mark

kriki

To do a lookup with the help of the properties, the field you want to select must be a part of the primary key.
The primary key of table "Service Item Line" is "Document Type,Document No.,Line No.". So field "Service Item No." is not a part of it.
If you want to select this field, you will have to write some code in the "OnLookup"-trigger of the field.

mark_christs

Thanks a lot for your answer and it works good.


rgds,
Mark