Welcome, Guest. Please Login.
05/15/25 at 15:57:26
News:
Home Help Search Login


Pages: 1
Send Topic Print
Maintain Grid Lookup - Can you look at two FD's? (Read 360 times)
stew
Browser
*


Semper Fi

Posts: 36
Gender: male
Maintain Grid Lookup - Can you look at two FD's?
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?
Back to top
 
 

EVO 9/27/07 update applied
Client/Server Win2003 Server
Pervasive SQL 2000i SP3
Email WWW stew   IP Logged
NovaZyg
Administrator
*****


When all else
fails.. Read the
instructions.

Posts: 789
Gender: male
Re: Maintain Grid Lookup - Can you look at two FD'
Reply #1 - 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.  
 
 Wink
 
Back to top
 
 

Allen Landry
Evo~ERP

EvoERP and DBA Classic always Beta's of the Latest versions.

WWW   IP Logged
Pages: 1
Send Topic Print