Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Looking for Solution for large lookup

2 views
Skip to first unread message

tig

unread,
Jul 23, 2009, 5:16:11 PM7/23/09
to
I have a form that may need to lookup as many as 300 fields from
another document. Any suggestions short of creating 300 column lookup
view? It seems there's got to be a better way.

Thanks in advance.

Joerg Mertens

unread,
Jul 24, 2009, 12:15:26 PM7/24/09
to
tig <tim....@micorp.com> writes:

When you use @dblookup, you can work with field names instead of column
numbers.

Joerg

JP

unread,
Jul 31, 2009, 11:11:16 AM7/31/09
to

I think its faster (and easier) to use:

value := @GetDocField(DocUNID; "FieldName")

Markg_UK

unread,
Sep 1, 2009, 12:01:40 PM9/1/09
to

why not encode the values into one field or two fields using "~" as a
separator then use
@Word( string ; separator ; number ) to get at the element you wish to
use.
Regards
Mark Gregory

0 new messages