Getting product dimensions based on selected itemid

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello, I am trying to produce the following screen,

the user selects an item,then selects the dimensions to generate a transfer journal.How can I filter the dimensions based on the selected item?

I have added inventdim datasource and dimensions datagroup, however the selected item's dimensions (size,color,style) doesnt show up on the lookups.Is there any example that I could use to produce this screen?

1104.Screenshot_5F00_1.jpg

Actually the purchline's item selection is a good example to that, however I couldn't figure out how it does that.

Regards

*This post is locked for comments

All responses (3)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Getting product dimensions based on selected itemid

*duplicate*
Community Member Microsoft Employee on at

Like (0)

Report

RE: Getting product dimensions based on selected itemid

Cheers,I did the relations with InventDim table, and if I filter Inventtable, all dims are listed based on the selected item.God bless abstraction :P
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Getting product dimensions based on selected itemid

You can use query objects to first look and then apply your dimensions when the user selects a new item number. Multiple ways to do this depending on the behavior you want. You could force most of the lookup code onto the validateWrite method if you have this in a custom table. If not, I would override methods on the forms datasource fields (either override modified method or performLookupMethod).