Making a custom browse

[Chris Farmer]

I am attempting to create a custom browse in .net that gives me information off the item master of a purchased child part and also gives the item number of the next direct parent. Is this possiable? I am stumped as to which table and field I should use for the parent part,

Any advice would be greatly appreciated.

Edit* I'm an idiot, i was not linking the fields together and was not getting output, problem fixed

 

[kishorchari]

Chris, this should help;

for each ps_mstr where ps_comp = PARTNBR and
can-find (pt_mstr where ps_comp = pt_part and pt_pm_code = 'P' no-lock :
disp ps_par pt_part pt_desc1 .
end.

 

[Chris Farmer]

I have the browse working the way I want it to work now, my next question is, when running 36.25.70 I assume that I use the Browse name of the browse I saved in Browse Maintenance, but what is the "to" field for? Is that just a field for what I want to name the .p?

Also, then would I need to compile it?

Thank you

 

[kishorchari]

You need to compile it. What option name is 36.25.70?

 

[Chris Farmer]

It is called browse generation utility.

 

[kishorchari]

Never used it..Ok.It looks good to me, compile it and place it in appropriate folder (First 2 characters) of browse name.