Page 2 of 2 < 1 2
Topic Options
#23698 - 08/19/10 06:12 PM Re: Grid View How to insert a field from another table [Re: BAMPH]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hi Peter,

You're right, the "Cat" prefix is not necessary for the solution, but I prefixed the string from the Category file with "Cat" so that it is obvious in the named item file that this refers to a category code (on the assumption that there may be other values in the file). In addition, it lets you trap an empty value with having to use an IF() statement.

Cat=** Empty entry **

since GETNAMEDITEM() returns and empty string if the value isn't found, you could also use:
Code:
IF(GETNAMEDITEM("Cat"&TRIM({Category}))="","!("&TRIM({Category})&") IS UNDEFINED!",GETNAMEDITEM("Cat"&TRIM({Category}))

which would highlight when the table needs updating.
_________________________
Andrew Bates

Top
#23701 - 08/20/10 05:13 AM Re: Grid View How to insert a field from another table [Re: Retired_Guy]
chinmook Offline
Edward Chris Chin-Mook

Registered: 09/29/09
Posts: 390
Loc: Jamaica
Thank you Andrew, I now understand, had a bit of a glitch as I had not updated my test bed machine with the latest Adagio Invoice release version 9.0 so the INSalesDtls.gv was not opening.

Can't beat having a practical demo file.

Real time support like this sets Adagio Accounting into a class by itself.

One Love...
_________________________
Edward C Chin-Mook
10 Waterloo Ave, Kingston 10, Jamaica
876-754-7444
876-754-5513

Top
Page 2 of 2 < 1 2


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 50 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14467 Topics
70662 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30