ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> Maintain Grid Lookup - Can you look at two FD's?
http://www.istechforum.com/YaBB.pl?num=1178894750

Message started by stew on 05/11/07 at 07:45:50

Title: Maintain Grid Lookup - Can you look at two FD's?
Post by stew on 05/11/07 at 07:45:50

Anyone know how to add a second table/file or link to a new table in "Maintain Grid Lookups"? I have a request from some users to add the "Description" of the parent Item to the BOMMSTR_WU (BOM WHERE USED) GRID.

Since that field is not in the BKBMMSTR table I am not sure how to link to another table. Is this even possible?

Title: Re: Maintain Grid Lookup - Can you look at two FD'
Post by NovaZyg on 05/11/07 at 09:10:16

Yes, it is possible. but it is not easy. You need to write your own program to do it. The grids allow for UDF (User Defined Functions). These functions get compiled at runtime. So you can make a grid column return just about anything you want.

That said. There are some examples in a file called ISUDF.SRC that do exactly this type of thing, like get the Vendor name from the bkapvend file. That file was left out of the post by mistake, but we are putting together a patch and I will have Lynn include it.

To add a UDF to a grid, just type in a name when it asks for the field name for the grid (don't use the dropdown) make sure you enter the type ([A]lpha,[N]umeric,[D]ate,[I]nteger) and the length for the column. When you are done it will tell you you need to create a file called "fieldname.src" in this file is where you need to write your function.

Like I said, Yes you can add your own columns but it is not easy, you need to be able to program, and be a TAS7 programmer helps too.

;)