Add New Lookup Field to Item Card Page

Normajm · 2016-12-22

I can't seem to find the exact answer to this, so here goes. I created a new field in the Item table titled "Work Code". I added the field to the Item card. I set the Source Expression to DATABASE::"Work Type" (I didn't know how else to select that table) with the TableRelation/Table to "Work Type". Once I compile and run the Item card, "Work Code" shows as a caption, but in the control, it just shows the table number (200) which is a lookup field, but I unable to select a Work Code from the list and keep it on the Item Card. The "Work Type" table does have a "DropDown" entry.

Thank you for your kindness...

Sowkarthika · 2016-12-23

You have to define Table relation for Work Code in Item Table.

Check field Item in Item Journal Line table (83) to know how table relation is defined.

Kishorm · 2016-12-23

You should also set the source expression on the page field to just "work code"

EDIT: should have said "work code" not "work type" - corrected

SuD · 2016-12-23

You should define "Table relation" property for that field in Item table..

Sowkarthika · 2016-12-23

You have to define Table relation for Work Code in Item Table.

Check field Item in Item Journal Line table (83) to know how table relation is defined.

Kishorm · 2016-12-23

You should also set the source expression on the page field to just "work code"

EDIT: should have said "work code" not "work type" - corrected

SuD · 2016-12-23

You should define "Table relation" property for that field in Item table..

Normajm · 2016-12-25

Thank you all! It worked perfectly!

Add New Lookup Field to Item Card Page

Best Answers

Answers

Categories